Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default VB control's text/caption is ugly - keeps resizing

Is there anyway to "lock in" a VB control's caption/disply text so it
doesn't keep resizing/squishing/expanding. For example, I have a
checkbox control on a worksheet that when I check it, the caption
resizes just a bit making it really ugly. Shouldn't "Arial 10point"
stay Arial 10point...and not squished Arial, almost 10 point?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 533
Default VB control's text/caption is ugly - keeps resizing

You might switch to a check box from the Forms toolbar. They are a bit more
'stable'.


--
Jim
"John" wrote in message
...
Is there anyway to "lock in" a VB control's caption/disply text so it
doesn't keep resizing/squishing/expanding. For example, I have a
checkbox control on a worksheet that when I check it, the caption
resizes just a bit making it really ugly. Shouldn't "Arial 10point"
stay Arial 10point...and not squished Arial, almost 10 point?



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
autofit text when resizing text box in Excel 2007 tinks Excel Discussion (Misc queries) 0 May 4th 09 04:20 PM
how can i print workbook text after resizing cells to fit text TP Excel Discussion (Misc queries) 2 October 18th 06 05:47 PM
changing image control's picture path No Name Excel Programming 2 October 5th 04 08:09 PM
Permanently change CheckBox control's value use VBA Ilona Excel Programming 1 February 27th 04 10:27 PM
reference an ole image control's .Picture filename? bdcrisp[_22_] Excel Programming 3 January 3rd 04 04:41 PM


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