Comment/Prompt with Drop Down List

  • Thread starter Thread starter Carmen
  • Start date Start date
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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
drop down list 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop-Down List 3
Conditional Drop Down List 1
Double Drop-Down Validation in Excel 2007 1
Linking drop down lists to another list 4
Drop down list ???? 1

Back
Top