![]() |
#4
|
|||
|
|||
![]() Quote:
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. |
Tags |
data validation |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Webbn111 | Excel | 9 | 03-09-2016 04:30 PM |
![]() |
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 |