listbox doubleclick

[alexanderd]

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

 

[Zathras]

There is a DblClick event you can process (Look in the right-hand combo box in the code window for a list of events that can be trapped.)

 

[alexanderd]

either i have missunderstood your reply, or!!

i am using a listbox in excel2002 sheet2 holds all the data for the listbox

 

[fumei]

Select the Listbox.
Right click
Select View Code
When code window opens, there is a dropdown at upper right. It should show "Click" - the default event. Select "DblClick" from dropdown choices.


Gerry

 

[alexanderd]

Ta i will try that tommorow

 

[alexanderd]

thank you works a treat