If Active cell is in column F then..

[omairhe]

Hey Excel Gurus,

I want your help to find the value of the adjacent cell on the left when the selection or the active cell is residing in column F.
For instance the data is

Column E	Column F
ABC	STU
DEF	VWX
GHI	YZ0
JKL	123
MNO	456
PQR	789

When Selection is F1 then output in A1 = ABC
Selection is F2 , A1 = DEF
Selection is F3, A1 = GHI
Selection is F6, A1 = PQR

The A1 is linked to a UDF which filters out data in column C.

Hope it is clear what is needed here.
As always will appreciate, and thanks many.

 

[RoryA]

Sounds like a SelectionChange code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If ActiveCell.Column = 6 Then Range("A1").Value = ActiveCell.Offset(, -1).Value
End Sub

 

[omairhe]

Sounds like a SelectionChange code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If ActiveCell.Column = 6 Then Range("A1").Value = ActiveCell.Offset(, -1).Value
End Sub

Thank you RoryA