Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-14-2017, 02:07 PM
NoSparks NoSparks is offline Data Validation Using Choice/Definition Columns Windows 7 64bit Data Validation Using Choice/Definition Columns Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Quote:
the definition of each choice is fairly detailed and not readily discernible as to selection
this makes me think there might be too much to put in the second column of a combobox but you can always try.

Put an activeX combobox on the sheet. Set its properties ie: size, columncount, font size, listfillrange, etc.
Use a macro such as Worksheet_SelectionChange to set its visibile and location properties.
Then the comboboxes change event to write to the sheet and hide the combobox.

I've never had much success working with controls on a sheet and with data validation the font size is always an issue.

I'd probably use Worksheet_SelectionChange to bring up a user form that has the definitions easy to read along with option buttons or check boxes for the user to make their selection and then write back to the target cell.
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 10:33 AM.


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