VBA double click event

[Sharkie21]

Trying to set up a double click event. It does what I want it to do, except for the fact when I double click it goes into the cell showing the formula. Is it possible to just double click the cell and not have it go into the formula / cell value?

 

[VoG]

You need this near the beginning

Cancel=True

 

[Andrew Poulsom]

You need to set:

Cancel = True