VBA UserForm in Excel -- timeout issue RRS feed

  • Question

  • Hi, I am using a simple VBA UserForm in Excel for pushing data into worksheets. I typically tab through the fields in the form as I am entering data, but if stop on a field for more than a minute or so, then Tab will no longer move cursor to the next field (it will then tab four spaces in same field).

    A timeout of some sort must be occurring, though I don't know if it's a timeout with the Form; or possibly the Tab Index sequencing; or something else. Anyone here ever encounter this or know how to change the timeout value of the Form or the source of this timeout? Thank you.
    Monday, January 16, 2012 5:24 AM