View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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!


.