How to give combo box the focus

[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

 

[Dave Peterson]

Maybe you can use something like:

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

 

[Nigel]

Hi Dave

I didnt realise it was that simple.

Thanks Nigel