Cancel Edit Mode 4

[oholloway]

I have some code that executes in the "Before DoubleClick" portion of a worksheet.After the code finishes, the cell that was clicked goes into edit mode. Is there any way to cancel that effect or make it go back into regular mode through VBA?

 

[xlbo]

sendkeys {ESC}

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[xlbo]

...or Range("Whatever Range").select

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[oholloway]

Thank you but what module does that need to be placed in? Worksheet,ThisWorkbook,etc.

 

[combo]

Another option: set Cancel=True (all in worksheet's module)

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
MsgBox "DoubleClick"
Cancel = True
End Sub

combo

 

[FaneDuru]

Application.EditDirectlyInCell = False

Fane Duru

 

[oholloway]

Thank you all for your responses

 

[SkipVought]

Hi,

I notice that for nearly 3 years, you have posted and replied 11 times and have received many good tips related to your stated needs. Yet, you have responded NOT ONCE, to
[blue]
Thank Tek-Tip Contributor
for this valuable post![/blue].

The Stars accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

And third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.


Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}