Command Button Issue

[JK]

Sometimes On_Click the CB on my sheet (created with the Control Toolbox)
continues to appear as if it's pressed down (even after the procedure it
calls finishes). But it looks odd. Can anyone suggest what I can do to
correct this strange behavior?

Thank you in advance.

Jim Kobzeff

 

[Rob Bovey]

Sometimes On_Click the CB on my sheet (created with the Control Toolbox)
continues to appear as if it's pressed down (even after the procedure it
calls finishes). But it looks odd. Can anyone suggest what I can do to
correct this strange behavior?

Hi Jim,

Try putting the following lines of code at the beginning of the Click
event (if you're displaying a UserForm in the Click event, put them
immediately after you dismiss the UserForm):

Application.ScreenUpdating = False
Application.ScreenUpdating = True

This doesn't always work, but most of the time it will force Excel to
refresh its window and get the appearance back to normal prior to running a
long procedure.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *