excel macro - macro initiation upon hitting the ener key
 

(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

--
Message posted from http://www.ExcelForum.com

excel macro - macro initiation upon hitting the ener key
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"arunjoshi " schrieb im
Newsbeitrag ...
(a) how can i get a macro activated automatically when the enter key
is
hit in a partcular cell, say a1.

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


---
Message posted from http://www.ExcelForum.com/