Urgent: VBA Command Button Caption Problem

  • Thread starter Thread starter Disco
  • Start date Start date
D

Disco

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
 
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.
 
Back
Top