Command Button Font Size

[dougman824]

Hello,

I had a strange thing happening with my command buttons on my spreadsheet. When ever they were clicked they would have their text get smaller so after about 3 clicks you couldn't read what it said. I don't have any code changing the font on the boxes and I have the boxes set to not resize and move with the cells. I am stumped on what could cause this. Here is my code behind the buttons

Please Login or Register  to view this content.

fsrform_initialize does nothing but open my form and load up the text boxes

Please Login or Register  to view this content.

[gmr4evr1]

Not sure if this has anything to do with it, but screenupdating is not being turned back on (true) at the end of the 1st code you posted. From what I understand this must be set back to true at the end of the code.
In this case, since the code is just initializing the form, you may not even need those lines.

[dougman824]

I have it set to false there so as they are in the form they do not see the screen flashing around as they make changes in the form. Screen Updating is then set back to true when the close the form.

[gmr4evr1]

Yes, I use it myself a lot, although, I've never used it, nor have I ever seen it used when loading a userform. The problem is, with it turned of like that, if users are doing other things in excel, they may not work correctly until it is turned back on.

[dougman824]

The form has ShowModal=ture so they are not allowed to do anything in excel until they close the form.

I also found through and bunch of good old fashion googling that it seems to be a Microsoft bug that has to do with if a user has different display settings from their computer. I know for my coworker the text kept getting smaller when she clicked the button with her laptop undocked but then when it was docked the button worked perfectly