excel macro - macro initiation upon hitting the ener key

[arunjoshi]

(a) how can i get a macro activated automatically when the enter key i
hit in a partcular cell, say a1.

(b) how can i get a macro activated automatically when a particula
value (abc) is entered in a particular cell (a1) and then the enter ke
is hit

 

[Frank Kabel]

Hi
use the worksheet_change event for this. See
http://www.cpearson.com/excel/events.htm

In your case use something like
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Application.Intersect(Target, Range("A1")) Is Nothing Then _
Exit Sub
If Target.Cells.Count > 1 Then Exit Sub

With Target
If .Value = "" Then
msgbox "Empty cell entered"
elseif .value="abc" then
msgbox "abc entered"
End If
End With
End Sub