Can I automatically run a macro on data entry?

  • Thread starter Thread starter Deena
  • Start date Start date
D

Deena

I have a table of data that I sort using a Macro. However to improve user
friendliness I would like to start this when the data in cell A20 is entered
or updated. IS this possible?
 
Yes, by using worksheet_change as follows;
Sub worksheet_change(ByVal target As Range)

If Not Intersect(cell, Range("A20")) Is Nothing Then
'Call your sort macro
End If

End Sub
 
Back
Top