Command Button does not re-set once clicked

Discussion in 'Microsoft Excel Programming' started by Guest, Apr 8, 2006.

  1. Guest

    Guest Guest

    Hi, This must be a fairly simle one for all of you Exel Guru's. When I click
    on my Toggle Button to change to antother sheet it stays depressed. When I
    click it again and go back to the front sheet it looks normal. How do I
    ensure that it resets itself automatically. Must be easy but its driving me
    mad!!!

    Thanks
     
    Guest, Apr 8, 2006
    #1
    1. Advertisements

  2. Guest

    davesexcel Guest

    Jurrasicway Wrote:
    > ...When I click
    > on my Toggle Button to change to antother sheet it stays depressed.
    > When I
    > click it again and go back to the front sheet it looks normal. How do
    > I
    > ensure that it resets itself automatically.....
    > Thanks

    Sounds like you want a regular button, not a toggle button, a toggle
    works for different senarios, true if depressed, false if not, ect


    --
    davesexcel
    ------------------------------------------------------------------------
    davesexcel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31708
    View this thread: http://www.excelforum.com/showthread.php?threadid=531193
     
    davesexcel, Apr 8, 2006
    #2
    1. Advertisements

  3. Guest

    Tom Ogilvy Guest

    Use a commandbutton instead of a Toggle button. Your Toggle button is
    functioning as designed.

    --
    Regards,
    Tom Ogilvy


    "Jurrasicway" <> wrote in message
    news:...
    > Hi, This must be a fairly simle one for all of you Exel Guru's. When I

    click
    > on my Toggle Button to change to antother sheet it stays depressed. When

    I
    > click it again and go back to the front sheet it looks normal. How do I
    > ensure that it resets itself automatically. Must be easy but its driving

    me
    > mad!!!
    >
    > Thanks
     
    Tom Ogilvy, Apr 8, 2006
    #3
  4. Guest

    Guest Guest

    Thanks Tom, I thought it would be simple. When would you use a toggle button
    and not a command button?

    Regards.

    "Tom Ogilvy" wrote:

    > Use a commandbutton instead of a Toggle button. Your Toggle button is
    > functioning as designed.
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "Jurrasicway" <> wrote in message
    > news:...
    > > Hi, This must be a fairly simle one for all of you Exel Guru's. When I

    > click
    > > on my Toggle Button to change to antother sheet it stays depressed. When

    > I
    > > click it again and go back to the front sheet it looks normal. How do I
    > > ensure that it resets itself automatically. Must be easy but its driving

    > me
    > > mad!!!
    > >
    > > Thanks

    >
    >
    >
     
    Guest, Apr 8, 2006
    #4
  5. Guest

    Tom Ogilvy Guest

    When I wanted to indicate that a certain condition is set.

    Perhaps if I was working in two currencies. If the toggle button is down,
    then on currency is display. If the toggle button is up, another currency
    is displayed.

    Anything that dictated a light switch paradigm or a binary or ON/OFF
    paradigm as an example.

    --
    Regards,
    Tom Ogilvy


    "Jurrasicway" <> wrote in message
    news:...
    > Thanks Tom, I thought it would be simple. When would you use a toggle

    button
    > and not a command button?
    >
    > Regards.
    >
    > "Tom Ogilvy" wrote:
    >
    > > Use a commandbutton instead of a Toggle button. Your Toggle button is
    > > functioning as designed.
    > >
    > > --
    > > Regards,
    > > Tom Ogilvy
    > >
    > >
    > > "Jurrasicway" <> wrote in message
    > > news:...
    > > > Hi, This must be a fairly simle one for all of you Exel Guru's. When I

    > > click
    > > > on my Toggle Button to change to antother sheet it stays depressed.

    When
    > > I
    > > > click it again and go back to the front sheet it looks normal. How do

    I
    > > > ensure that it resets itself automatically. Must be easy but its

    driving
    > > me
    > > > mad!!!
    > > >
    > > > Thanks

    > >
    > >
    > >
     
    Tom Ogilvy, Apr 8, 2006
    #5
  6. Guest

    Guest Guest

    Thanks Tom.

    "Tom Ogilvy" wrote:

    > When I wanted to indicate that a certain condition is set.
    >
    > Perhaps if I was working in two currencies. If the toggle button is down,
    > then on currency is display. If the toggle button is up, another currency
    > is displayed.
    >
    > Anything that dictated a light switch paradigm or a binary or ON/OFF
    > paradigm as an example.
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "Jurrasicway" <> wrote in message
    > news:...
    > > Thanks Tom, I thought it would be simple. When would you use a toggle

    > button
    > > and not a command button?
    > >
    > > Regards.
    > >
    > > "Tom Ogilvy" wrote:
    > >
    > > > Use a commandbutton instead of a Toggle button. Your Toggle button is
    > > > functioning as designed.
    > > >
    > > > --
    > > > Regards,
    > > > Tom Ogilvy
    > > >
    > > >
    > > > "Jurrasicway" <> wrote in message
    > > > news:...
    > > > > Hi, This must be a fairly simle one for all of you Exel Guru's. When I
    > > > click
    > > > > on my Toggle Button to change to antother sheet it stays depressed.

    > When
    > > > I
    > > > > click it again and go back to the front sheet it looks normal. How do

    > I
    > > > > ensure that it resets itself automatically. Must be easy but its

    > driving
    > > > me
    > > > > mad!!!
    > > > >
    > > > > Thanks
    > > >
    > > >
    > > >

    >
    >
    >
     
    Guest, Apr 9, 2006
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Jamal

    Detrmine which command button was clicked

    Jamal, Nov 13, 2003, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    359
    Jamal
    Nov 14, 2003
  2. Flystar
    Replies:
    1
    Views:
    664
    BrianB
    May 26, 2004
  3. John

    Command Button font size increases when clicked

    John, Jul 3, 2004, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    597
  4. grime

    Change cell value when right-clicked/double-clicked

    grime, Oct 15, 2005, in forum: Microsoft Excel Programming
    Replies:
    5
    Views:
    579
    Haukwa
    Oct 17, 2005
  5. CAPTGNVR
    Replies:
    1
    Views:
    255
  6. RyanH

    Show Time Stamp in Cell when Command Button Clicked

    RyanH, Jan 18, 2008, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    337
    Sam Wilson
    Jan 18, 2008
  7. spy

    command button can't be clicked

    spy, Jun 16, 2008, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    203
    Gary Keramidas
    Jun 17, 2008
  8. NDBC

    Prevent a command button from being clicked twice

    NDBC, Jun 26, 2009, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    837
Loading...