View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Can I automatically run a macro on data entry?

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
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Deena" wrote:

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?