AUTOMATIC EXECUTION
Apologies.
I usually add instructions on where to place the code.
An oversight this time.
Gord
On Fri, 28 Dec 2007 15:00:00 -0800, VB_User
wrote:
I finally figured it out (it wasn't obvious) - that I must enter the "Change"
macro in the sheet rather than for the workbook!!!
Thank you. It's just what I've been looking for for the last few months.
"Gord Dibben" wrote:
A particular cell or a range of cells or?
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in any cell in Col A
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
With Target
If .Value < "" Then
yourmacroname
End If
End With
End If
enditall:
Application.EnableEvents = True
End Sub
Gord Dibben MS Excel MVP
On Fri, 28 Dec 2007 12:51:03 -0800, VB_User
wrote:
I would like to execute a macro every time the "Enter" key is depressed (or
an entry is made to an Excel cell). Is there a way to do this with a special
macro (Visual Basic)? Or, is there another way?
|