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]

HERE & HERE is some decent reading

 

[CrashDDL]

Sorry for the late reply, it was so late I fell asleep. So the UserForm is triggered on the main page of the Workbook when price or qty is changed to start the recording of a sale. When a second item is created by upgrading the base item, the UserForm looks up the possible upgrades from the specific account the base item is from. User then selects the used parts and with Enter continues the archiving of the trade. At this point the code will calculate itemCost, itemProfit etc and store it all on the Sold sheet. It is a bit more complicated than that but that would be the jist of it.

I already thought of KeyUp event just did not get around to change it yet, was so focused on the problem with Tab. I will test it out and identify the bit of code that causes the issue.