How to give combo box the focus

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I have seven combo boxes on a worksheet. After the code has run to add an
entry to the list I would like the next combo box to take the focus and so
on, preferably with a differentbackground colour if possible.

Thanks in advance
Nigel
 
Maybe you can use something like:

With Worksheets("Sheet1")
.ComboBox1.Activate
.ComboBox1.BackColor = &H80000002
End With
 
Back
Top