Comment/Prompt with Drop Down List

C

Carmen

I have a spreadsheet that contains drop down list on several cells. How can
I add a comment or a prompt so that when certain categories are selected from
the drop down list, a prompt or comment pops up?

I'm lost. Please help!
 
G

Gary''s Student

You can use an event macro. Say cell A1 has a Data Validation dropdown and
one of the options is Horse. In worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
If Range("A1").Value <> "horse" Then Exit Sub
MsgBox ("see our prices for saddles")
End Sub
 
Top