| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a Origin Cell from Data Validation
I have a data validation list set up at "B16". The list goes from "I6" to
"I333". If I select an item from the drop-down list, for example, "UNITABC", it will appear in "B16". The value was taken from "I300", though. How do I, with VBA, refer that cell? I want to be able to output what cell ("I300") that is currently selected in the data validation drop-down list. Thanks Shawn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing data validation list in IF Statement | Excel Programming | |||
| Data Validation Restriction Referencing other Workbook | Excel Worksheet Functions | |||
| Referencing a range on a different tab than where data validation | Excel Discussion (Misc queries) | |||
| Referencing a data validation list | Excel Discussion (Misc queries) | |||
| Data validation referencing other cells' values | Excel Programming | |||
Threaded Mode
