View Single Post
  #2   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

Continuing to assume the combobox if from the Control Toolbox Toolbar
It still has a click event found in the sheet module


In design mode, double click on the combobox and you should go to a code
module with something like

Private Sub Combobox1_Click()

End Sub

Put your code there.

---------------------
If the combobox is actually a dropdown box from the forms toolbar, you would
right click on it and select Assign Macro. then Assign the macro you want
to run to the dropdown box.

Regards,
Tom Ogilvy


"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!



.