Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-14-2017, 05:33 AM
Phil H Phil H is offline Data Validation Using Choice/Definition Columns Windows XP Data Validation Using Choice/Definition Columns Office 2010 64bit
Advanced Beginner
Data Validation Using Choice/Definition Columns
 
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
 

Tags
data validation



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Using Choice/Definition Columns Data Validation - List Webbn111 Excel 9 03-09-2016 04:30 PM
Data Validation Using Choice/Definition Columns 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft