beforedoubleclick event vba call function

[davidpayten]

Hi All,

I am trying to double click on a cell and then pull back its children via calling a function to pull back the result.

I have the following code, but it does not seem to work:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
currentCell = ActiveCell.Address
Target.Address = Sheets("output").Range(currentCell).Address
x = Target.Address
Call GetChildrenPassString(x)

End Sub

Can someone tell me where I am going wrong??

cheers
Dave

 

[Leith Ross]

Hello davidpayten,

The named argument Target is the active cell or range of cells the user has selected before double clicking.

Sincerely,
Leith Ross

 

[davidpayten]

Hi Leith,

Its an active cell within a range. Maybe the range could be a1:a20 an the active cell would be in that range.

Cheers

Dave

 

[davidpayten]

can anyone help me here?? VBA noob here.

Cheers

dave