+ Reply to Thread
Results 1 to 8 of 8

Command Buttons Click Response

  1. #1
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Command Buttons Click Response

    Hi all, I have a really weird problem. In a workbook I have created, I am using command buttons on each sheet that will direct the user to other pages. Yesterday, they were working great. Now, everytime I click on one, the text on the button gets larger with every click. It has gotten to the point where even the button colour/color has clicked oph (with multiple clicks). Has anyone ever heard ov a problem like this?
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,750

    Re: Command Buttons Click Response

    I have this problem when I am using my laptop hooked up to a monitor with a different resolution than the laptop monitor. I have never figured out why, or how to fix it. My problem is somewhat the opposite; the monitor resolution is higher than the laptop monitor and when I click buttons they get smaller and smaller.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Command Buttons Click Response

    I didn't think it to be relevant but thanks for pointing that out 6string. I was working via remote desktop on a 42" phlat panel in a conpherence room. Mayhap it was the resolution that did it. It was very strange and I had to go through all the buttons to phix them aphter. There should be a way to lock the buttons so that it doesn't happen, isn't there? Anyhow, thanks phor your input.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Command Buttons Click Response

    still no f's then lol
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Command Buttons Click Response

    Quote Originally Posted by martindwilson View Post
    still no f's then lol

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,750

    Re: Command Buttons Click Response

    Quote Originally Posted by Mordred View Post
    I didn't think it to be relevant but thanks for pointing that out 6string. I was working via remote desktop on a 42" phlat panel in a conpherence room. Mayhap it was the resolution that did it. It was very strange and I had to go through all the buttons to phix them aphter. There should be a way to lock the buttons so that it doesn't happen, isn't there? Anyhow, thanks phor your input.
    I had the same result when giving a presentation with a projector with a resolution that didn't match the laptop's display resolution. Everything looks OK when you bring it up but every time you push a button, it changes size--buttons, radio buttons, every kind of control.

    Haven't figured out how to force them to stay locked.

  7. #7
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Command Buttons Click Response

    Is there a way to edit the text inside a command button with VBA? I can mess with the width, size, and other dimensions of the button but when I use:
    Please Login or Register  to view this content.
    I receive an error. There has to be a way to figure this problem with controls out.

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,750

    Re: Command Buttons Click Response

    I have done this with ActiveX controls using code like what you show, but don't know how to address the older Form controls. Maybe you've got Form controls.

+ 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