How can I reset a CommandButton that gets stuck in its 'clicked' position?

TIA

Matthew

Are you sure this is a toggle switch and not a command button??


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=571080

Also, a commandbutton will stay depressed as long as its event code is
executing.

--
Regards,
Tom Ogilvy

"Matthew" wrote in message
...
How can I reset a CommandButton that gets stuck in its 'clicked' position?

TIA

Matthew

Thanks for the replies...

The problem is... I have a form with CommandButtons that is used for data
entry. I had a problem that if I needed press the same button twice I had
to wait for it to be ready. With advice from Die_another_day I added some€¦

Private Sub CommandButton1_DblClick(ByVal cancel As MSForms.ReturnBoolean)

routines and that solved the problem.

The problem now is that if my data entry ends in a double click the
commandbutton is left in its 'clicked' state which seems to stop other
buttons from working.

This is probably caused by the code CommandButton1.Enabled = false which
runs if 'end of data entry' condition is satisfied. I think the button is
being disabled before it has chance to 'unclick'.

Hope this makes sense!

Thanks

Matthew

"Tom Ogilvy" wrote:

Also, a commandbutton will stay depressed as long as its event code is
executing.

--
Regards,
Tom Ogilvy

"Matthew" wrote in message
...
How can I reset a CommandButton that gets stuck in its 'clicked' position?

TIA

Matthew