View Single Post
 
Old 11-14-2017, 02:07 PM
NoSparks NoSparks is offline Windows 7 64bit 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