Combobox is highlighted when loading userform... -- SendKeys ("{TAB}") --

[MistakesWereMade]

I have a userform that I load but the combobox is selected... I don't want the cursor blinking in my combobox when the userform is opend. I currently use sendkeys for Tab as it will move the selection to the next button which is fine. Is there a different way to code this rather than having to rely on the sendkeys command?

My code is below:

Private Sub CommandButton1_Click()


UserForm1.Show vbModeless
SendKeys ("{TAB}")


End Sub

 

[Steve_]

No code needed.

Go into your form design and adjust your "TabStop" (True/False...Tab either CAN find it or WONT find it based on this) and then of course adjust your Tab Index. Lowest number gets first focus. So be sure the combobox is NOT the lowest Tab Index.

Enjoy.


(and in case it isnt clear...When the user hits 'Tab', it will cycle through ALL objects (with a tab stop set to TRUE) in the sequential order..Tab Index 0, then 1, then 2, then 3...so on and so forth..

When it reaches its highest Tab index, it will cycle back to the lowest and start all over.

 

[MistakesWereMade]

You SIR, are MARVELOUS! Thanks.

 

[Steve_]

Happy to help. Let us know if there is anything else