excel macro - macro initiation upon hitting the ener key

A

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
 
F

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
 
Top