Strange Tab Key Behavior

I have a userform with about 20-30 textboxes. When users use the tab
key to navigate, it will work, then all of a sudden just stop. The tab
stays inside the textbox and tabs over spaces inside the userform
textbox, but it does not jump to the next box. This seems to be
intermittent, if the user restarts the form, it goes away, but
eventually it sometimes returns to this weird behavior. Has anyone
come across this, i am puzzled???


---
Message posted from http://www.ExcelForum.com/

There's a tabkeybehavior property that sounds like is set to true for some and
false for others.

If you select the textbox (when you're designing the form), hit F4 to show its
properties, you can see that .tabkeybehavior.

Check out VBA's help for more info.

You could also use some code to set this property:

Option Explicit
Private Sub UserForm_Initialize()
Dim ctrl As Control
For Each ctrl In Me.Controls
If TypeOf ctrl Is MSForms.TextBox Then
ctrl.TabKeyBehavior = False
End If
Next ctrl
End Sub




"bg18461 " wrote:

I have a userform with about 20-30 textboxes. When users use the tab
key to navigate, it will work, then all of a sudden just stop. The tab
stays inside the textbox and tabs over spaces inside the userform
textbox, but it does not jump to the next box. This seems to be
intermittent, if the user restarts the form, it goes away, but
eventually it sometimes returns to this weird behavior. Has anyone
come across this, i am puzzled???

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson