Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you change either the size of the text box or the size of the source
data in a drop down text box when created through data validation?
 
You can't change the font or font size for a Data Validation dropdown
list. To make the font appear larger, you can use programming to adjust
the zoom setting when the cell is selected. There's sample code here:

http://www.contextures.com/xlDataVal08.html#Larger

Or, there's a sample file here that provides a combobox from which you
can select one of the values from the data validation list. In
thecombobox, you can set the font size:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation text size 1
How to edit the size of a drop-down list (using data validation)? 1
Validation list in data entry form 4
How do you control the font size of the data validation field? 1
Test in Validation Box Very Small Font Size... 1
Data Validation Error 1
EXCEL-2000 column headings hide from data 3

Back
Top