View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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