![]() |
|
#3
|
|||
|
|||
|
NoSparks, Thanks for your reply - appreciate your time.
The problem is the definition of each choice is fairly detailed and not readily discernible as to selection - but accuracy is important. Using DV, I can present the choices, but I want the user to see the definition as well. Needed: when the user clicks a cell, a list of choices and their definitions appear (a ComboBox variation?). The choices and definitions (range) are located elsewhere in the worksheet. Clicking on a choice, that choice is populated in the cell. The choice/definition display disappears after the selection. I presume this requires a macro, but maybe there is another way - don't know. VLookup? |
| Tags |
| data validation |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Data Validation - List
|
Webbn111 | Excel | 9 | 03-09-2016 04:30 PM |
Update data connection - path, database name, query definition
|
jaworski_m | Excel | 1 | 08-03-2015 02:37 AM |
| Paste over data validation | saurabhlotankar | Excel Programming | 2 | 05-24-2015 11:52 PM |
| If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |