Problem disabling double click event

N

Neil Will

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?
 
N

Neil Will

Joined
May 22, 2014
Messages
2
Reaction score
0
Solved my own question! Basic error!! It is the double click event of the individual listbox that needs to be cancelled.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Event handler 4
double click not working 4
Click event for UserForm Multipage 1
Double Click Jump 2
Double click event 7
Double-click date entry 2
re-enabling the double click 4
double click event search in other workbook 2

Top