|
|
#1
11-13-2017, 08:49 AM
|
|||
|
|||
Data Validation Using Choice/Definition Columns
Need a data validation macro for choice/definition:
......L ............M 5 Choice 1 Definition 1 6 Choice 2 Definition 2 7 Choice 3 Definition 3 When user invokes the macro (using the down arrow in the target cell), L5:M7 is displayed. User selects one of the L cells, which is populated in the target cell For example: User clicks L6, target cell is populated with Choice 2. The purpose is to put definitions in front of the user to insure accurate selection. 
|
| 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 |
Windows XP 
Office 2010 64bit
Threaded Mode