Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Urgent: VBA Command Button Caption Problem


Thanks in advance for any help.

I have just created a few command buttons (VB buttons)on a spreadshee
and gave them captions. However the font size of the button captio
keeps shrinking every time I press it. How can I fix the problem?

Thanks a lot

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 459
Default Urgent: VBA Command Button Caption Problem

I got a similar effect the other day with ActiveX comboboxes on a
worksheet: every time they were dropped-down they increased in size
fourfold! I think the font size may have been affected too. I had
changed screen size (via Control Panel) since the workbook had been
opened. The resolution was: don't change the screen size while the
workbook is open! A temporary fix was to re-initialize the size,
position, font etc of the combobox in the dropdown event i.e. the
event that was causing the problem.

Disco wrote in message ...
Thanks in advance for any help.

I have just created a few command buttons (VB buttons)on a spreadsheet
and gave them captions. However the font size of the button caption
keeps shrinking every time I press it. How can I fix the problem?

Thanks a lot.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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
Change caption of a button Dylan @ UAFC[_2_] Excel Worksheet Functions 3 November 25th 08 07:04 PM
Command Button Problem albertmb Excel Discussion (Misc queries) 6 June 22nd 08 01:06 PM
Problem with command button name Jason[_9_] Excel Discussion (Misc queries) 10 October 19th 07 09:54 PM
strange command button problem David Excel Discussion (Misc queries) 0 March 20th 06 03:06 PM
Problem with VB running from a command button Tim Marsh[_2_] Excel Programming 3 July 31st 03 11:14 AM


All times are GMT +1. The time now is 09:18 PM.

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

About Us

"It's about Microsoft Excel"