Automatic advance between textboxes on a userform

Hey there. I must be missing something with this code.
On a userform, I am attempting to be in a textbox called txtPTagLtr. When 1 character is input (can be anything) it will automatically advance to the next text box called intPTagNo.

Here is the code I have:

Please Login or Register  to view this content.

I have even gone so far as to go into the textbox properties of txtPTagLtr and change max length to 1; auto tab to True. If I look at the tab index positions, the textbox txtPTagLtr is 2, and the intPTagNo is 3.


Any ideas why it wont automatically advance when a character is input?

Originally Posted by Norie

The code works for me, anything else going on in the userform code?

No. Most of the code is on the cmdButton. I have had the cursor do the following for me:

* go backwards to the last textbox filled in before this one
* go to the desctiption text box (its listed as number 15 on the tabindex)
* go to the description textbox 2 textboxes down (set at number 17 on the tabindex)

Driving me crazy................

Originally Posted by scott micklo

No. Most of the code is on the cmdButton. I have had the cursor do the following for me:

* go backwards to the last textbox filled in before this one
* go to the desctiption text box (its listed as number 15 on the tabindex)
* go to the description textbox 2 textboxes down (set at number 17 on the tabindex)

Driving me crazy................

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Anyone with any ideas or thoughts with this?? I am stumped beyoind belief on this one. Anything that I can possibly look for?

thanks so much in advance

Any ideas why it wont automatically advance when a character is input?[/QUOTE]
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Anyone with any ideas or thoughts with this?? I am stumped beyoind belief on this one. Anything that I can possibly look for?

thanks so much in advance

Any ideas why it wont automatically advance when a character is input?[/QUOTE]
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Anyone with any ideas or thoughts with this?? I am stumped beyoind belief on this one. Anything that I can possibly look for?

thanks so much in advance

Any ideas why it wont automatically advance when a character is input?[/QUOTE]