drop down menus inside worksheet- (validation) - how do I change .

[Guest]

I have had lots of fun creating a spreadsheet with a few pull down menus.
These were made using the validation function.
Now I need to resize the font in the drop down menu...
please advise!!!!

 

[Gord Dibben]

You cannot change the font-size in a DV drop-down.

For workaround using Zoom see Debra Dalgleish's info at........

http://www.contextures.on.ca/xlDataVal08.html#Larger

Gord Dibben Excel MVP

 

[ForSale]

try using the combobox on the control toolbox. right click on the to
and make sure that control toolbox is checked, then click on the on
titled combobox, then insert it on the screen. hit alt+f11. make sur
that the properties window is on by going to View | Properties window.
you can change the font and what not there.
then click on the sheet that the combobox is on, and paste:

Private Sub Worksheet_Activate()
With ComboBox1
.AddItem "item"
.AddItem "thing"
End With
End Su