Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. -- RobVos ------------------------------------------------------------------------ RobVos's Profile: http://www.excelforum.com/member.php...o&userid=34859 View this thread: http://www.excelforum.com/showthread...hreadid=546090 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double Click to run a sub then re-initializes userform?? Why???
I mis-typed the above -- it is the Active sub that is running again, not the Initialize sub. -- RobVos ------------------------------------------------------------------------ RobVos's Profile: http://www.excelforum.com/member.php...o&userid=34859 View this thread: http://www.excelforum.com/showthread...hreadid=546090 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
userform label double-click goes to click event | Excel Programming | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
CommandBarButton click vs. double click | Excel Programming | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming |