run macro after press enter key

[prakashkumar]

dear sir,
run macro after i press enter key.
ex ; if i type p in cell A1 and macro should run

 

[offthelip]

the easiest way to do that is to use the workhseet change event. write click on the worksheet tab, then view code and select the worksheet change event

Private Sub Worksheet_Change(ByVal Target As Range)
' put your code in here
End Sub