Msg Box Based On List Box Selection (1 Viewer)

[HeelNGville]

I have a form that contains a list box with 11 separate options. Within this list is the option named "None". My desire is to have a message box displayed when any option is selected other than "None". I have searched various threads, however I have been unsucessful nailing down my issue. Thanks in advance for the assistance.

 

[FNM]

I would do something like

if comboboxname.value = "None" then
exit sub
else
Msgbox "You have selected " & comboboxname.value & " as your option"
end if

I'd put that on the afterupdate

where you can change the combobox name to whatever yours is called and change your message to whatever you want.

Hope thats of help