Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate macro1
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate macro1
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate macro1
You can get Excel to do this for you.
Go to ToolsOptionsEdit and check the Move selection after Enter box, and choose your direction. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |