Maybe you can use something like:

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



Nigel wrote:

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