Please help a poor lost girl!

[buntykins]

Does anyone know what code I need to put into my form so that when hit command button 1, the cursor goes straight to combobox3. Also where do I put it? In the Exit code for command button 1 or what?

Janie

 

[smozgur]

combobox3 on sheet or form?

 

[buntykins]

On a userform

x

 

[Ian Mac]

if the button is on the shet or userform (i.e. to load it).

right-click on the button, select view code.

you should get

Private Sub CommandButton1_Click()

End Sub.

Type:

ComboBox1.SetFocus

you should have

Private Sub CommandButton1_Click()

ComboBox1.SetFocus

End Sub

should do the trick!

 

[smozgur]

Private Sub CommandButton1_Click()
ComboBox3.SetFocus
End Sub

And if you also want to combobox3 dropdown then

Private Sub CommandButton1_Click()
ComboBox3.SetFocus
SendKeys "%{DOWN}"
End Sub


Regards

 

[buntykins]

Thanks guys, I owe you one

xx