Command Button Anomaly

[John Wilson]

I have a commandButton on a worksheet that calls up a UserForm.
If I click the button, bring up the UserForm and then exit the form
the caption on the button gets messed up (almost like the caption
was overwritten but shifted slightly).
Anyone ever run into this (and possibly a way to fix it)?
(TakeFocusOnClick is set to False although it acts the same
either way.)

Thanks,
John

 

[Tom Ogilvy]

sounds like a screen redraw problem (perhaps). Do you have screenupdating
set to false? Does it clear up if you minimize the sheet, then maximize
it?

 

[John Wilson]

Tom,

Re: Does it clear up if you minimize the sheet, then maximize it?
Yes it does.

I tried this from another post of yours:
DoEvents
Application.ScreenUpdating = False
Application.ScreenUpdating = True
DoEvents
and it seems to work.

Thanks,
John