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.
|