Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We are getting inconsistencies with a User Form in how the Tab key
functions. There are times when it advances from form field to form field, and other times when it only advances the cursor within the active form field. Why is this not consistent and how can we control this? We want the Tab to always advance to the next field. Note: We are using automation on this form to get data from Outlook; but that should not affect anything. Any clues? Bert |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You need to check the "Tab order" of the controls placed on your userform.
With the form displayed, from the View menu, choose "Tab order". There you can check and set the tab order. Regards, Edwin Tam http://www.vonixx.com "BTuohy" wrote: We are getting inconsistencies with a User Form in how the Tab key functions. There are times when it advances from form field to form field, and other times when it only advances the cursor within the active form field. Why is this not consistent and how can we control this? We want the Tab to always advance to the next field. Note: We are using automation on this form to get data from Outlook; but that should not affect anything. Any clues? Bert |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have you looked at the TabKeyBehavior property of the controls?
-- Regards, Tom Ogilvy "BTuohy" wrote: We are getting inconsistencies with a User Form in how the Tab key functions. There are times when it advances from form field to form field, and other times when it only advances the cursor within the active form field. Why is this not consistent and how can we control this? We want the Tab to always advance to the next field. Note: We are using automation on this form to get data from Outlook; but that should not affect anything. Any clues? Bert |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The TabKeyBehavior and Multiline are always set to FALSE---I should have
mentioned that at the onset. Curiously, however, ComboBoxes are also affected. "Tom Ogilvy" wrote in message ... Have you looked at the TabKeyBehavior property of the controls? -- Regards, Tom Ogilvy "BTuohy" wrote: We are getting inconsistencies with a User Form in how the Tab key functions. There are times when it advances from form field to form field, and other times when it only advances the cursor within the active form field. Why is this not consistent and how can we control this? We want the Tab to always advance to the next field. Note: We are using automation on this form to get data from Outlook; but that should not affect anything. Any clues? Bert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel inconsistency | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |