How to change text in from down list visible/bigger

[chrisdq]

Hi,

I'm working on a excel sheet that has some drop down lists, but the sheet has many columes (50 col.) and rows with a height of 150) big enough to write on like a notebook sheet. Therefore, I have to change all the text to size 72 or more to make it big enough when print out.
Normally the test with font size 14 is ok to see but when I stretch row height to 150 everything seems so small and I have to change font size to 72 or more for text to be normal.

My problem is, some columes have some drop down lists but the choices/text from the droppped down list is too small to see. The default text size for drop down is about 12. Not only too small to see but also too small for faxing.
Does any expert in here know how to change the text from drop down list bigger to 30 or 72. or make the font size for text stay the same when I have many rows with heights about or close to the size from a notebook.

I'd really appreciate any one can help me with my problem.

Thank you very much in advance.

 

[byundt]

chrisdq,
There is no provision for making the font size larger in Data...Validation dropdown lists. Microsoft suggests using a ComboBox from the Controls ToolBox toolbar, which does have a property for font size.

Here is a different workaround, which changes the Zoom percentage when you select a cell with a Data...Validation dropdown. This code needs to be pasted in the code pane for the worksheet. You may want to play around with the zoom percentage (set to 600 in the sample code).

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Dim i As Long
On Error Resume Next
i = Target.Cells(1, 1).Validation.Type
If i = 3 Then
  ActiveWindow.Zoom = 600
Else
  ActiveWindow.Zoom = 100
End If
End Sub

Brad

 

[chrisdq]

Byundt,

Thank you very much for your help.
It's good to know that it's not possible to change the font size from drop down list using validation.

I find combo box as an alternative solution. It works great
except that the user now have to enable macro in order to take advantage of the combo box options.

I was wondering, does everyone have to change the macro security to Media/Low??? Might be annoying or make people insecured when open the sheet.

The big question I have is can I change the color of the drop down list window to black or something like the validation list? I have the last line blank but the user might not see it as a choice.

Thanks a million to everyone helping.

 

[jonsi]

The big question I have is can I change the color of the drop down list window to black or something like the validation list? I have the last line blank but the user might not see it as a choice.

Instead of leaving your User a black line as a choice for blank I would be inclined to give them the option of <None>. It's more definite than choosing a blank and can always be filetered out.

 

[jonsi]

further to my last comment...

if you create an option of <none> this will always be at the top of a sorted list.

also ...you could Conditionally format your dropdown to Cell Value is equal to <none> so that a selection of <none> can colour the background and font to whatever colours you require eg both font and background white.

 

[chrisdq]

Thank you very much for your help.

Your help really save me lots of time.
You deserve 5 stars in this forum.