Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default Displayed caption font increases on each click

Hi Eddie,
I also had this trouble a while back and found this solution.
http://support.microsoft.com/kb/838006/en-us

Exit Excel
Scroll down to the section "More Information" and follow the 11 steps
listed. Relaunch Excel and click away to see if it took.

If this doesn't work, you might need a service pack update. Ignore the fact
that the article indicates a root cause of screen resolution change.

"Eddie" wrote:

My "fix" did not hold. I.e., "Deleting the controls, saving and exiting the
template, reopening, setting
my zoom to 85%, and THEN redefining the controls seems to have worked."

I have not had this issue with any other templates. Only difference I can
tell is that I have moved from Excel 2002 SP2 to Excel 2003 SP2.

Any other thoughts? I can hardly pass this off as professional level
quality as it now stands. Thanks.

"Eddie" wrote in message
...
Working in Excel 2003 SP2, I have three command buttons which, when
clicked, will have their displayed captions increase in size -- getting
larger on each run.
1. When I go into VBA properties for the command button, the font setting
is unchanged.
2. Furthermore, getting the VBA font property to reset the display
doesn't seem to work well. It's as though it associates the current
displayed font (call 76, maybe) with the current properties font (say 12).
So changing the property font from 12 to 10, say, still displays as big.
And once you have reset to the smallest font available, you are basically
stuck.

I haven't a clue and have not seen this before. Autosize is off, as is
TakeFocusOnClick.

Thanks in advance. Larry.


Reply
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
UserForm - Stop updating the caption after I click on. Alex St-Pierre Excel Programming 2 May 14th 08 02:08 PM
Text box caption=Cell Value (without command click) Bafa[_5_] Excel Programming 2 August 21st 06 03:03 AM
Help with formatting right-click menu caption. Delmar D'Percy Excel Programming 2 March 14th 06 01:54 PM
button caption font shrinking JeffP Excel Programming 1 August 15th 05 11:06 PM
Command Button font size increases when clicked John Excel Programming 0 July 3rd 04 12:09 AM


All times are GMT +1. The time now is 11:56 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"