dropdown box item to display a message

[grocottg]

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

 

[Susan]

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