none
Weird appearance of user form while clicking on its buttons. RRS feed

  • Question

  • Hello,

    It's my first experience with user forms, and I see something weird. There are a few buttons on the form. When I push a button down, the form appears to pop up (and a dark shadow forms around it).

    When I release the button, the form pops down again, and its shadow disappears.

    So, when I click a button repeatedly, the user form gives the impression that it is dancing up and down (i.e. in and out of the screen). It's weird!

    I understand that buttons give the impression to pop up and down. But why should the form dance with the button?

    There is surely a property I should modify. But what?

    Sorry I can't post a video...

    Thanks

    Leon


    Monday, November 18, 2019 6:17 PM

Answers

  • Hi Leon,

    I've installed Office 2007 (Japanese) and checked if I could reproduced.
    I did not reproduce. (see the below)
         

    And I've installed Service Pack 3, but could not reproduce the issue.

    Please try to repair your Office 2007.
      Control Panel > [Programs and features] > select Office 2007 abd [Repair]

    Regards,

    Ashidacchi -- http://hokusosha.com

    • Marked as answer by Leon Lai Tuesday, November 19, 2019 12:37 PM
    Tuesday, November 19, 2019 3:21 AM
  • Hi Leon (Good morning from Japan),

    I make animation gif with "ScreenToGif".
    This is free and easy to use. Please try it.

    Regards,

    Ashidacchi -- http://hokusosha.com

    P.S.
      Has the issue resolved?
      I've found the article about repairing. If the issue still remains, try this.
      Repair an Office application


    • Edited by Ashidacchi Tuesday, November 19, 2019 10:36 PM
    • Marked as answer by Leon Lai Wednesday, November 20, 2019 10:28 AM
    Tuesday, November 19, 2019 10:25 PM

All replies

  • Hi Leon Lai,

    Please provide the code (in the button) and Excel version.

    Regards,

    Ashidacchi -- http://hokusosha.com

    Monday, November 18, 2019 11:42 PM
  • Hi, Ashidacchi

    Thanks for your reply.

    My Excel version is 2007 ( I am on leave for a few days and I am working on my home laptop which uses Office 2007).

    The button code is not important. I get the same effect with only this simple code in the button click event:

    MsgBox "xxx"

    There is a shadow around the User Form.

    When I click on the button, the shadow disappears and the message pops up.

    When I click OK to clear the message, the shadow reappears around the form.

    It is this appearing and disappearing which generates the weird dancing effect when I click a button (with real code) repeatedly.

    I will try with newer Excel version when I resume work in a few days.

    Best Regards,

    Leon

    Tuesday, November 19, 2019 2:28 AM
  • Hi Leon,

    I've installed Office 2007 (Japanese) and checked if I could reproduced.
    I did not reproduce. (see the below)
         

    And I've installed Service Pack 3, but could not reproduce the issue.

    Please try to repair your Office 2007.
      Control Panel > [Programs and features] > select Office 2007 abd [Repair]

    Regards,

    Ashidacchi -- http://hokusosha.com

    • Marked as answer by Leon Lai Tuesday, November 19, 2019 12:37 PM
    Tuesday, November 19, 2019 3:21 AM
  • Thanks a lot again.

    Would you mind telling me how you did your animation? It's fantastic!

    Leon Lai

    Tuesday, November 19, 2019 12:37 PM
  • Hi Leon (Good morning from Japan),

    I make animation gif with "ScreenToGif".
    This is free and easy to use. Please try it.

    Regards,

    Ashidacchi -- http://hokusosha.com

    P.S.
      Has the issue resolved?
      I've found the article about repairing. If the issue still remains, try this.
      Repair an Office application


    • Edited by Ashidacchi Tuesday, November 19, 2019 10:36 PM
    • Marked as answer by Leon Lai Wednesday, November 20, 2019 10:28 AM
    Tuesday, November 19, 2019 10:25 PM
  • Hi, Ashidacchi.

    Many thanks again for ScreenToGif.

    I tried my VBA code on my office computer, and everything worked normally.

    So, I think there is a problem with the Excel on my home laptop. Don't bother.

    Best Regards,

    Leon

    Wednesday, November 20, 2019 10:28 AM