Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Drop Down Using VBA?
Is there a way to programmatically cause a drop-down list in a cell with
validation to show? On one of my worksheets, if the user enters a certain value in one cell, another cell is populated with a list of titles the user must choose from. I would like that list to automatically show ("drop down") to remind the user to select something. Thanks, Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Drop Down Using VBA?
Hi - Why not just use a visual cue instead. Maybe change the color of the cell in question when the other value is entered. You could either do this with code to just change the range /cell interior color, or you could setup conditinal formats prior to any macros running, or you could do a combination of both. As well, you can setup your dv lists to prompt the user on input or invalid entry. This would require the user to be in the cell w the list though. "egun" wrote: Is there a way to programmatically cause a drop-down list in a cell with validation to show? On one of my worksheets, if the user enters a certain value in one cell, another cell is populated with a list of titles the user must choose from. I would like that list to automatically show ("drop down") to remind the user to select something. Thanks, Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation drop-down | Excel Discussion (Misc queries) | |||
Data validation drop-down box | Excel Discussion (Misc queries) | |||
Drop down data validation | Excel Discussion (Misc queries) | |||
Data Validation - Drop Down | Excel Worksheet Functions | |||
Data Validation Drop-Down Will Not Appear | Excel Programming |