How to DeSelect a Double-clicked cell in VBA?

[SteveInAlabama]

I have a data entry range, and if the operator double-clicks on a cell in that range, I want to Show a Form related to that row using the Worksheet_BeforeDoubleClick event. I have the Application.Intersect part working fine.

But when I double-click the cell, it goes into Edit mode, with the cursor flashing in the cell, ready to edit its contents. I want to escape out of the Edit mode using VBA code. How is this done?

Thanks in advance!

 

[Norie]

Add this to the code.

Cancel = True

 

[SteveInAlabama]

Perfect!!! Thank you!

 

[codsmith]

Finally after searching everywhere for this... THANK YOU!