| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comment/Prompt with Drop Down List
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comment/Prompt with Drop Down List
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 -- Gary''s Student - gsnu200767 "Carmen" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| Bypass prompt to open XML file as XML list? | Excel Discussion (Misc queries) | |||
| Is there a way to prompt a list in a function? | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
