Thread: Activate macro1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default 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