Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not exactly, but you can trigger a macro any time you go to cell S8 (either
via mouse or keyboard) using the Worksheet_SelectionChange event. Put the following code in the sheet module: Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$S$8" Then Macro1 End Sub Macro1 should be in a standard module and not designated as Private. -- Vasant "IRMA MENDOSA" wrote in message ... I Have this template the fills up a deposit slip and the only thing that i have to do is fill up the amount in cell S7 and then press enter to go to cell S8 Is there a way to activate macro1 when i hit enter to go to next cell wich is S8 Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
App activate issue | Excel Worksheet Functions | |||
Can't activate an add-ins | Setting up and Configuration of Excel | |||
If sheet name contains 'A' run macro1, if 'B' run macro 2? | Excel Discussion (Misc queries) | |||
When to Activate? | Excel Discussion (Misc queries) | |||
Activate event | Excel Programming |