msgbox prompt when user selects data from combo box
If you allow a user to type an entry into the combobox, it fires on every
keystroke - that would be a difference.
Regards,
Tom Ogilvy
"Dan E" wrote in message
...
Private Sub ComboBox1_Change()
MsgBox Prompt:="You have selected " & _
ComboBox1.Value, Buttons:=vbOKOnly
End Sub
I chose the change event over the click event, don't know if theirs a
whole
lot of difference??
Dan E
"tjb" wrote in message
...
Thank you for your response.
The combo box is on the sheet itself, not on a user form,
what would I enter for a click event?
-----Original Message-----
Use the click event of the combobox if it is from the
Control Toolbox
toolbar.
Regards,
Tom Ogilvy
"tjb" wrote in message
...
When a user selects data from a combo box, how can I
have
a message box prompt or User Form pop up?
Once again I know this is an easy one but I'm still
learning VBA!
.
|