Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - VBA Code execution in Excel | New Users to Excel | |||
Macro Execution | Excel Discussion (Misc queries) | |||
How to automatic calculation and macro execution between 3 workbooks? | Excel Worksheet Functions | |||
function execution | Excel Worksheet Functions | |||
function execution | Excel Worksheet Functions |