+ Reply to Thread
Results 1 to 2 of 2

Double Click to run a sub then re-initializes userform?? Why???

  1. #1
    Registered User
    Join Date
    05-26-2006
    Posts
    3

    Double Click to run a sub then re-initializes userform?? Why???

    I have a userform that has a listbox that contains data in 7 columns. I also have a command button that when clicked allows the user to edit the data in whatever row of the list box is highlighted. This works fine.

    I decided to have a double click in the listbox on a row do the same thing. So I simply picked the double click event and called the command button sub. When I try this, it runs the command button sub, but then it runs the userform initialize sub. This is a problem as it does thing that I do not want to occur again.

    I then decided to put the command buttom code in a separate sub and then call that sub on the double click -- same result.

    Anyone know why this happens, I see no reason for it.
    Last edited by RobVos; 05-26-2006 at 08:38 PM.

  2. #2
    Registered User
    Join Date
    05-26-2006
    Posts
    3
    I mis-typed the above -- it is the Active sub that is running again, not the Initialize sub.

+ 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