Urgent: VBA Command Button Caption Problem

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
 
O

onedaywhen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top