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

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