View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default dropdown box item to display a message

you could try something like

Private Sub ComboBox1_Change()

if combobox1.value = "xyz" then
msgbox "You've chosen the wrong entry!"
end if

End Sub

although i don't know if you're using a listbox or a combobox, and if
it's from the control toolbox or the forms toolbar.
hope that gets you started.
:)
susan


On Nov 19, 4:18*am, grocottg
wrote:
Hi,

I would like to run a Macro so that if someone selects an item from a
dropdown box, a message will appear. Is this possible?
The dropdown box is already created.

Thanks for any help