LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I change font size in a dropdown menu I created? THECORBYLOON New Users to Excel 1 August 27th 06 11:08 PM
how can I change the font size on a validation list [email protected] Excel Programming 2 October 20th 05 07:41 PM
How to change the font size of Validation List? OKLover[_2_] Excel Programming 1 August 6th 05 05:47 AM
How do I change the size of font/display in a dropdown list I've . Steve Excel Programming 0 April 8th 05 07:13 PM
Change font size in drop down validation lists Big Daddy Excel Discussion (Misc queries) 2 February 3rd 05 05:22 PM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"