Command Button Anomaly
 

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

Command Button Anomaly
 

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?

--
Regards,
Tom Ogilvy

"John Wilson" wrote in message
...
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

Command Button Anomaly
 

Tom,

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

"Tom Ogilvy" wrote in message
...
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?

--
Regards,
Tom Ogilvy

"John Wilson" wrote in message
...
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