Re: Displayed caption font increases on each click



Tom, that describes the problen exactly. But I have always set my zoom at 85% in my apps, and I have never seen this behavior before. Still, very much appreciate the reference. Now probably just need to play with a bit and see if I can get around. I think I'll delete my exisitng controls, save, reopen, and redefine. And see what happens. Thanks.

"Tom Ogilvy" <TomOgilvy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3C029B2E-002B-4298-98E4-17A7A3016D69@xxxxxxxxxxxxxxxx
I found an article that related this to the zoom setting on the *** being
less than 100%. It was for Excel 2000, so may not be pertinent.

http://support.microsoft.com/kb/211866/en-us

--
Regards,
Tom Ogilvy


"Eddie" wrote:

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.


.