Drop Down Combo box and tabbing

[kellitenille]

I have a dropdown Combo box, and figured out how to tab from the combo box to next cell. Now, the last piece of the puzzle to make my file perfect, is that, when I open the file, the cursor will automatically be in the combo box, since it is my first cell. Ideas?? I can attach my file if someone tells me how!

 

[MrIfOnly]

Copy this code to your worksheet module for the worksheet where the combobox resides changing the name of the combobox as necessary:

Private Sub Worksheet_Activate()
    ComboBox1.Activate
End Sub

This should put the focus on the combobox whenever the worksheet is selected.

Regards,

CJ

 

[kellitenille]

That doesn't seem to be working for me, however my allergy medicine is making me brain dead. Is there a way for me to attach my file so that you can see it?

 

[MrIfOnly]

You can't attach a file directly in this forum, but you can upload your file to a file-sharing website and then post the link to that here.

CJ