Tab out of a UserForm > ListBox ?

[CrashDDL]

Hi,

As the title says. How can I "Tab" out of a ListBox on a UserForm?
I don't understand why, the ".SetFocus" will move cursor to "ListBox2" but focus jumps back after "End Sub".
Anyone has a suggestion for this?

Private Sub ListBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

    If KeyCode = 9 Then ListBox2.SetFocus

End Sub

 

[CSmith]

Why are you not just setting the tab order for the userform under view menu in VBIDE?

 

[CrashDDL]

VBIDE

What is VBIDE? Also I have many things on the UserForm but I only allow navigation between 1 x txt, 3 x button and 2 x listboxes. If I can get the Tab out to work from the listboxes...

 

[CSmith]

well the tab is going to move between the controls and you can disable them in tab stops and put them in any order. The VBIDE is the window opens when you click Visual Basic versus just the Macro Window, you can edit/add a macro and it will make a chunk of visual basic code and the editor is the 'Visual Basic Integrated Development Environment' or VBIDE.

 

[CrashDDL]

Sorry, wasn't aware of the VBIDE name... of course I know what it is now :D
So I did all that. Only the items that I want to be selected have TabStop Enabled.
The problem is that I can't seem to be able to "Tab" out of a "ListBox". Neither of them want to let it happen.
It drags the Focus back for some reason. "Tab" result just won't stick...

 

[CSmith]

Make sure each has a tabstop: true and tabindex: order (tab order can also be set using the ide)
Mine worked fine tab switches between controls just fine with NO additional code attached to the control...

 

[CrashDDL]

I arrived to the same conclusion. I will have to keep adding the other code bits one by one and check to see which one has this unwanted effect.

 

[CSmith]

RARELY do you want keydown to have code...

 

[CrashDDL]

Any suggestion on what to use instead if I want to trigger a macro when Enter is pressed for example?

 

[CSmith]

Keyup better than Keydown... What are you doing in the macro, or using the macro for?