Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I understand that there's no way to control the font SIZE for dropdown text
using validation (Excel 2002). I'm trying to simulate an onfocus event to change the display percentage to 200% when cell D2 is selected, but it isn't working. Here's the code, can anyone tell me what I'm doing wrong? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$D$2" Then ActiveWindow.Zoom = 200 Else ActiveWindow.Zoom = 100 End If End Sub Thanks, in advance, for your help. G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I change font size in a dropdown menu I created? | New Users to Excel | |||
how can I change the font size on a validation list | Excel Programming | |||
How to change the font size of Validation List? | Excel Programming | |||
How do I change the size of font/display in a dropdown list I've . | Excel Programming | |||
Change font size in drop down validation lists | Excel Discussion (Misc queries) |