+ Reply to Thread
Results 1 to 4 of 4

Reset a commandbutton

  1. #1
    Matthew
    Guest

    Reset a commandbutton

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

    TIA

    Matthew



  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Are you sure this is a toggle switch and not a command button??

  3. #3
    Tom Ogilvy
    Guest

    Re: Reset a commandbutton

    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
    >
    >




  4. #4
    Matthew
    Guest

    Re: Reset a commandbutton

    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
    > >
    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1