View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Combo Box Control

Here is the solution that I figured out.

I placed a public variable in my Module and referred to
it in these to procedures.

Brad

Public HasentGoFocusYet as Boolean '(This is in the
Module)

'These are in the worksheet code page

Private Sub ComboBox5_Change()
If HasentGoFocusYet = True Then
Cells(ActiveCell.Row, ActiveCell.Column -
1).Select
HasentGoFocusYet = False
End If
End Sub

Private Sub ComboBox5_GotFocus()
HasentGoFocusYet = True
Sheets("Flock Sheet").ComboBox5.DropDown
End Sub



-----Original Message-----
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
.