Double click to run a macro

[famdamly]

I need to have the macro run only with a double click instead of a single. Is there a simple way to do this?

[jasoncw]

Are you talking about double-clicking on a command button? Yes, that is possible. You can insert your code in the following event handler procedure (assuming the button is CommandButton1):

Private Sub CommandButton1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

' Your code here

End Sub

HTH

Jason

[famdamly]

Thanks. Much appreciated.

[jasoncw]

No problem.