View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default need help with custom validation drop down lists.

You can set a font size and color using a combo box from the control
toolbox.

Right click any toolbar and select Control Toolbox.
Click the Design Mode icon (top left icon that looks like a blue triangle)
Click the Combo box icon then navigate to where you want the list.
Use your mouse and "draw" the combo box
Right click the combo box and select Properties
Here you can select font size and color (among various other options)
On the Alphabetic tab, select Font, select the font and size desired.
Select Forecolor, on the Palette tab set the font color
As the source for the list select ListFillRange and type in your named range
If you want to use the selected item in some calculation then you have to
link the combo box to a cell. For example, A1. Then your formula would
reference this linked cell. Select LinkedCell and enter the cell address.

After you're done click the Design mode icon to exit design mode. Close the
control toolbox toolbar.

--
Biff
Microsoft Excel MVP


"Capt. Cave Man" wrote in message
...

All the help I could find allows me to change the font and size of a
drop down list in the excel toolbar. What I want to do is change the
font and size of a validation list in the worksheet itself.

I was unable to find any reference to it. I have a list that points at
a named range for the hour of the day, but my drop down list is so tiny I
can barely read it.

Does anyone know how I can change it.

For that matter, the information boxes that are part of the validation
dialog pops up in a box I would like to size and even change the color
of.

Can that be done, or is it tied to the Windows OS help system or
something?