Yep, never noticed that till now, that does suck. Thanks for pointing that
out...

Dan E

"Tom Ogilvy" wrote in message
...
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!


.