View Single Post
 
Old 11-14-2017, 05:33 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

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?
Reply With Quote