View Single Post
 
Old 12-24-2017, 09:27 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

No problem.

You can use a standard range in the Worksheet_SelectionChange macro by restricting things to specific column and rows,
for example column E and rows 4 to 20.
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

'limit to single cell selection
If Target.Count > 1 Then Exit Sub
'limit to specific column
If Target.Column <> 5 Then Exit Sub
'limit to specific rows
If Target.Row < 4 Or Target.Row > 20 Then Exit Sub

    ' do what's required, example
    MsgBox "The sheet address of the cell you just entered is " & Target.Address
    '
    
End Sub
Reply With Quote