AUTOMATIC EXECUTION
 

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?

AUTOMATIC EXECUTION
 

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?

AUTOMATIC EXECUTION
 

hi
use the worksheet_selectionchange event.
This will cause code to run whenever the cells on the sheet change.

Regards
FSt1

"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?

AUTOMATIC EXECUTION
 

Somehow nothing works. I insert the suggested subroutine, but it never
executes. I've seen the same suggestion, with commands included, in other
posts - but I get no response. Am I using the wrong version of Visual Basic?
I'm using Excel 2003 and the VB that comes with it.

"FSt1" wrote:

hi
use the worksheet_selectionchange event.
This will cause code to run whenever the cells on the sheet change.

Regards
FSt1

"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?

AUTOMATIC EXECUTION
 

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?

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?