Software

Ask something
Discussion Locked

Excel Drop-down list font

0 helpful
7 replies

by rossmore

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Does anyone know how to change the font in a drop-down list in Excel? I do not need to change the font in the cells that the drop-down list data is stored or the cell where the data is displayed, I want the font in the actual drop-down list larger for my users. Thanks for any help in advance.

7 replies

by cptomlly

Sounds like you are talking about a combobox control? You can edit font size by rightclicking the control, choose properties. Then find the font listing, and click the ... button on the right.

Hope this helps.

by rossmore

CptOmly, This isn't a combo control box in Access, it is a Data Validation cell with a drop-down list. You create it by going to Data, Validation, and selecting List. I want to change the font of the selection items on the drop down for that cell, there are no properties option, just format cell.

by dklippert

Always hate to answer can't be done, but the font can not be changed.
Here is a macro that works with the Change event to enlarge the cell.
Right click the worksheet tab and choose "See Code"
Paste this in (change $A$2 to the address of the validation cell)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$2" Then
ActiveWindow.Zoom = 120
Else
ActiveWindow.Zoom = 100
End If
End Sub

A not very satisfactory solution.
For more see:
http://tinyurl.com/2cqaz

by rossmore

Doug's answer and URL was very helpful and I appreciate the time he took to send that out.

This discussion is closed to new replies.