Excel - start macro by doubleclicking cell 1

[48Highlander]

Is there some way I can achieve this?

Bill J

 

[SkipVought]

Hi,

Take a look at Worksheet Events in the VB Editor.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[48Highlander]

Thanks Skip. I have the following code in the sheet module:

Private Sub Worksheet_SheetBeforeDoubleClick(ByVal Sh As Object, _
        ByVal Target As Range, ByVal Cancel As Boolean)


    MsgBox "Test"
    Cancel = True

End Sub

When I double-click a cell in the worksheet, nothing happens. What am I not seeing?

Bill J

 

[KenWright]

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Application.EnableEvents = False
    MsgBox "test"
    Cancel = True
Application.EnableEvents = False
End Sub

Regards
Ken...........


----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[48Highlander]

I tried adding both
Application.EnableEvents = True
and
Application.EnableEvents = False

to my code but this sheet module still does not work when I double click on it.




Bill J

 

[SkipVought]

Your code is NOT in the worksheet object.

It's in the ThisWorkbook object.

RIght click the sheet tab and select View Code.

Select the BeforeDoubleclick Event and put your 2 lins of code in there

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

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}