View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
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/