How can I reset a CommandButton that gets stuck in its 'clicked' position?
TIA
Matthew
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??
Also, a commandbutton will stay depressed as long as its event code is
executing.
--
Regards,
Tom Ogilvy
"Matthew" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > How can I reset a CommandButton that gets stuck in its 'clicked' position?
> >
> > TIA
> >
> > Matthew
> >
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks