View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
G G is offline
external usenet poster
 
Posts: 52
Default Validation Dropdown Font Size Change

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