View Single Post
 
Old 11-13-2017, 08:49 AM
Phil H Phil H is offline Windows XP Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default 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.
Reply With Quote