double click (excel2002)

Topic

New Reply

i have a list box with 4 colums of which the first colum sets up the stage for a macro to run.
in order to get the macro to run i have to click on a command button.
can any one suggest a method whereby i double click within the list box to run the macro

Reply | Quote

Replies

If the the list is on a form, you can use the dbl-click event

If the listbox is on a sheet and it is from the controls toolbox, you have dbl-click event

If the listbox is on a sheet and it is from FORMS toolbar, change it to the control toolbox list box and use the dbl-click event

Steve

Reply | Quote

If the the list is on a form, you can use the dbl-click event

If the listbox is on a sheet and it is from the controls toolbox, you have dbl-click event

If the listbox is on a sheet and it is from FORMS toolbar, change it to the control toolbox list box and use the dbl-click event

Steve

Reply | Quote