On Fri, 21 May 2004 10:25:58 -0700, "Brad"
wrote:

Thanks for taking the time to read my question.

I have a combo box that the user can choose values from.
Once the user has chosen a value I would like to move the
focus to a cell on the same worksheet. How do you do
this?

I've tried everything I know. I've looked in help
extensivly.

The combo box name is ComboBox5

Thanks so much,

Brad


You could try something like

Private Sub ComboBox5_Change()
ActiveSheet.Cells(3, 4).Select
End Sub

change the 3 and the 4 to your specific needs.

Hope this helps.

Lars-Åke