PDA

View Full Version : User form and tab key



ironj32
05-18-2007, 09:12 AM
i want to be able to tab through all of the controls. for all my controls i have the "TabKeyBehavior" = False, and "TabStop"=True. sometimes this feature works and sometimes it doesn't. any one have a reason for this?
Thanks

Bob Phillips
05-18-2007, 11:50 AM
You also have to set the tabindex property to the index number.

ironj32
05-18-2007, 11:53 AM
they are all set in the order i want. some times when a user is typing and press tab, it will actually tab (move 5 spaces) in the same text box. other times it will work flawlessly.

ironj32
05-18-2007, 11:53 AM
.

Aussiebear
05-19-2007, 02:21 PM
Any chance of posting your code so the people here can review the issue? It would be more positive than just posting a . , don't you think?

lucas
05-19-2007, 02:32 PM
Bob gave the solution to this in post #2.
set the tabindex property for each control....0 for the first control, 1 for the next one you want it to go to when you hit tab, 2 for the next, etc.

malik641
05-19-2007, 08:16 PM
they are all set in the order i want. some times when a user is typing and press tab, it will actually tab (move 5 spaces) in the same text box. other times it will work flawlessly.
Make sure "TabKeyBehavior" is not changed during runtime.

Can we see the code or an example workbook?

ironj32
05-21-2007, 06:04 AM
sorry for the delay, left early on friday. i have attached a copy of what i have. i didn't do any of the "tab stuff" with code, just in the property settings. thanks everyone!

Bob Phillips
05-21-2007, 06:13 AM
It tabs fine for me.

ironj32
05-21-2007, 06:16 AM
like i said, sometimes it works and sometimes it doesn't.

malik641
05-21-2007, 06:31 AM
Tabs fine for me too.

Is that sometimes for you or sometimes for other users? I'm wondering if it could be some setting (non-VBA) that could set it off...although I doubt it.

Bob Phillips
05-21-2007, 07:25 AM
If you can't give a situation where it doesn't work, it will be very difficult to solve.