Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change caption of a button | Excel Worksheet Functions | |||
Command Button Problem | Excel Discussion (Misc queries) | |||
Problem with command button name | Excel Discussion (Misc queries) | |||
strange command button problem | Excel Discussion (Misc queries) | |||
Problem with VB running from a command button | Excel Programming |