dropdown box item to display a message
 

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

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