Page 1 of 2 12 LastLast
Results 1 to 10 of 14

HELP! Tabbing within the UserForm

This is a discussion on HELP! Tabbing within the UserForm within the Excel Questions forums, part of the Question Forums category; Sometimes my UserForm decides to use the Tab key to Tab within the field rather than to the next field!! ...

  1. #1
    Board Regular
    Join Date
    Jan 2003
    Posts
    97

    Default HELP! Tabbing within the UserForm

    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!)

  2. #2
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,962

    Default

    Check the TabKeyBehavior property. TRUE will have TAB act as the regular, good-old TAB key.
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  3. #3
    Board Regular
    Join Date
    Jan 2003
    Posts
    97

    Default

    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.

  4. #4
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,962

    Default

    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
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  5. #5
    Board Regular
    Join Date
    Jan 2003
    Posts
    97

    Default

    still having the same issue

  6. #6
    Board Regular
    Join Date
    Jan 2003
    Posts
    97

    Default Re: HELP! Tabbing within the UserForm

    Anymore suggestions on why TabKeyBehavior might be switching to TRUE in the middle of a UserForm?

    Anyone

  7. #7
    Board Regular
    Join Date
    Jan 2003
    Location
    Palm Coast, Florida
    Posts
    264

    Default Re: HELP! Tabbing within the UserForm

    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

  8. #8
    New Member yash_patil21's Avatar
    Join Date
    Jan 2010
    Posts
    7

    Default Re: HELP! Tabbing within the UserForm

    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

  9. #9
    New Member
    Join Date
    Jan 2012
    Posts
    7

    Default Re: HELP! Tabbing within the UserForm

    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 ..

  10. #10
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    16,607

    Default Re: HELP! Tabbing within the UserForm

    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)

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com