How to trigger a macro on cell *selection*

NoSparks · #4 12-24-2017, 09:27 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Limit min and max number to a cell based on country selection	hussainshaikh1	Excel	1	02-02-2017 07:06 AM
How do I trigger a macro from a document?	brucemc777	Word VBA	4	01-25-2016 01:42 AM
Selection from cell with list contents autopopulates contents of another cell	markharper80	Excel	3	02-16-2015 04:18 PM
Hyperlink in cell to trigger pop up text box	Carpie	Excel Programming	0	08-13-2013 10:33 AM
ms office excel 2007 cell selection issues	pavamaklava	Excel	1	05-12-2010 10:47 PM