Sendkeys VBA

[ericdmc85]

Hi,

I have a vba from another post to enable edit mode on a cell without double clicking. It works on the entire worksheet. How do I make it applicable to only certain column, say column F. VBA code I have for the entire worksheet is below:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
SendKeys "{F2}"
End Sub

 

[rollis13]

Change your code to this:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("F:F")) Is Nothing Then SendKeys "{F2}"
End Sub

 

[ericdmc85]

Thanks you!!

 

[rollis13]

Thanks for the positive feedback, glad having been of some help.
By the way, you probably need to mark this thread as 'Solved'.