Get value of a column in same row when double click

[Grant0519]

I am trying to get the value of a column frm the same row as I double click to be placed in the cell I am clicking.

Have managed to produce an offset value but how can I make it choose a value from the column?

Thanks in advance

 

[Fluff]

Hi & welcome to MrExcel
Something like

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True
   Target.Value = Range("B" & Target.Row).Value
End Sub

 

[Grant0519]

Hi & welcome to MrExcel
Something like

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True
   Target.Value = Range("B" & Target.Row).Value
End Sub

Awesome that works perfectly, Thanks

 

[Fluff]

Glad to help & thanks for the feedback