Problem disabling double click event

Joined
May 22, 2014
Messages
2
Reaction score
0
I am writing an application using Excel 2007 in which I have a User Form with a list box from which the user has to select, consecutively, values for 3 different variables. If the user selects these with a single click, it runs fine. But if the user accidentally double clicks when selecting a value, then that value is assigned to both the correct variable and the next one. I want to disable the DoubleClick Event to prevent this happening. I have tried setting Cancel to True in the Sub Workbook_SheetBeforeDoubleClick, but this doesn’t work. Any thoughts?
 
Solved my own question! Basic error!! It is the double click event of the individual listbox that needs to be cancelled.
 
Back
Top