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