Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Font in my command button keeps changing

Status
Not open for further replies.

PeteG

Programmer
Feb 23, 2001
144
GB
Hi,
I wonder if anybody else has come across this and if there is a solution...

I have several command buttons on a worksheet and all have a _Click event written for them. All is working well, ie click on the button, the event is fired and my code gets executed.

I have one cosmetic problem that I have not yet been able to explain...sometimes, after having clicked on the button, the font of the caption text might get bigger or appear to become bold. It can get to the point where the caption becomes unreadable as the font gets so big that only part of it is visible. If I manually resize the button, the font returns to normal and all is calm again!

I cannot understand it! Btw, my code is not making any change to the caption - it is a static piece of text that just seems to take on a life of its own when clicked on!

Anyone else seen anything similar?
 



Hi,

Select the object and select Format Control - PROPERTIES tab, and select a positioning option that does not RESIZE the object.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 





Select the control object.

Select Format COntrol

Select the Properties Tab

Select an position option and does not RESIZE the object.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 



Hi,

Select the control object.

Select Format COntrol

Select the Properties Tab

Select an position option and does not RESIZE the object.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Thanks for your replies, Skip!

They were all set to 'Move but don't size with cells' (which I assume to be the default). I have changed them all to 'Don't move or size with cells' and I'll see how it goes.

Thanks very much for your advice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top