+ Reply to Thread
Results 1 to 2 of 2

User Form Buttons: Delayed response

  1. #1
    Registered User
    Join Date
    09-29-2009
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    5

    User Form Buttons: Delayed response

    Hello all!
    I am experiencing some odd behavior with a UserForm, the user must click on a button twice to trigger the onClick event.

    This odd behavior only occurs when I call the procedure to show the form through a custom menu. When I execute the procedure from the VBA window, the form behaves properly.

    The UserForm is a very basic About box to display version and notes. It has a command button for closing it with the following:
    Please Login or Register  to view this content.

    The procedure to show the forms:
    Please Login or Register  to view this content.


    Using the procedure below gets proper response from the command button.
    Please Login or Register  to view this content.

    Using the procedure below emulates the call from a menu. This causes the odd behavior of clicking twice to get the event to trigger.
    Please Login or Register  to view this content.

    In summary: What gives?

  2. #2
    Registered User
    Join Date
    09-29-2009
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: User Form Buttons: Delayed response

    An addendum after some further debugging...

    The onClick event is being called when a button is clicked, I traced it using debug.print.

    The command to hide the form is what requires two clicks to register when called via menu or application.run

    Very odd! Any thoughts?

+ 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