Tabbing within the UserForm

jbailey2

Board Regular
Joined
Jan 5, 2003
Messages
97
Sometimes my UserForm decides to use the Tab key to Tab within the field rather than to the next field!!

Any suggestions? (The TabKeyBehavior property is already set to False!)
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Isn't it the other way around?? This is from the Excel VB Help file:
Value Description
True Pressing TAB inserts a tab character in the edit region.
False Pressing TAB moves the focus to the next object in the tab order (default).

That was my point ... TabKeyBehavior is already set to false and we still ocassionally have the problem as if it was set to True.
 
Upvote 0
When I said good-old way TAB normally works, I meant that it tabs out....or spaces out....well, you know. Try running this code and see if the behavior still happens:

Code:
Private Sub UserForm_Initialize()
Dim Ctl As Control
    For Each Ctl In UserForm1.Controls
        MsgBox TypeName(Ctl)
        Select Case TypeName(Ctl)
            Case "TextBox"
                Ctl.TabKeyBehavior = False
        End Select
    Next Ctl
End Sub
 
Upvote 0
Anymore suggestions on why TabKeyBehavior might be switching to TRUE in the middle of a UserForm?

Anyone :(
 
Upvote 0
Well, this probably won't help but I have had the same experience as well. The light I can shed for you is that its not a problem with "my" tab key behavior, its usually been an error in my code. Like a textbox exit procedure or something like that. Sorry I can't be more specific, its hasn't happend in a while. But I would nose around in your code a little.

DaK
 
Upvote 0
Hello Dear

from last few day i am also working on userfrom and i m having the same problem like tab key pressing with in the combobox or textbox

if any one having solution please help me out
 
Upvote 0
Hi, I realize this is an old thread, but I'm having same issue and have not found solution. I do have an additional clue, though!

Tab key input in text box inserts old-fashioned tab space in the box, ONLY after I have lingered in a text box for a minute or two, so there may be some sort of time-out issue occurring. If I swiftly tab through the fields while entering data in them, I never have a problem.

My settings for ALL the text-box controls all seem to be correct:

TabKeyBehavior is set to False; and the related control, MultiLine, is also set to False.

still a mystery ..
 
Upvote 0
What control is exhibiting this problem?
If it is in a Frame or a MultiPage what is the .Cycle property?
(.Cycle is a property of a single Page, not the whole MultiPage)
 
Upvote 0

Forum statistics

Threads
1,213,533
Messages
6,114,179
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top