R
RobVos
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.
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.