Correct coding entry of VBA macros in Excel worksheet

It has been some years since I needed this application. On an Excel
spreadsheet I need to enter [via VBA Editor] a sequence of 3 macros which
will activate a "running total" in each cell. I have the code, but not sure
how to enter [type] in the Editor page.
--
WJR

In the VBIDE window (Ctrl-G), just type the macro names and return, or
select them from the Excel app via Alt-F8, and select and run from the
list.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack R" <jgoose@excel2003.com> wrote in message
news:C8C28FE1-3626-46B2-9CE5-E897966FC8A7@microsoft.com...
> It has been some years since I needed this application. On an Excel
> spreadsheet I need to enter [via VBA Editor] a sequence of 3 macros which
> will activate a "running total" in each cell. I have the code, but not
sure
> how to enter [type] in the Editor page.
> --
> WJR

Bob: Thanks, will give both options a try. Also if I want a range of cells
to be RT [running total] active, will the macros do so anytime I open the
worksheet? Or must I select all the cells and do something else?
Gracias!
--
WJR


"Bob Phillips" wrote:

> In the VBIDE window (Ctrl-G), just type the macro names and return, or
> select them from the Excel app via Alt-F8, and select and run from the
> list.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jack R" <jgoose@excel2003.com> wrote in message
> news:C8C28FE1-3626-46B2-9CE5-E897966FC8A7@microsoft.com...
> > It has been some years since I needed this application. On an Excel
> > spreadsheet I need to enter [via VBA Editor] a sequence of 3 macros which
> > will activate a "running total" in each cell. I have the code, but not
> sure
> > how to enter [type] in the Editor page.
> > --
> > WJR
>
>
>

If your code uses a Selection range, then you will need to select it each
time.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jack R" <jgoose@excel2003.com> wrote in message
news:E8726C51-6E84-488F-9AB1-FAE0BC3C6E52@microsoft.com...
> Bob: Thanks, will give both options a try. Also if I want a range of
cells
> to be RT [running total] active, will the macros do so anytime I open the
> worksheet? Or must I select all the cells and do something else?
> Gracias!
> --
> WJR
>
>
> "Bob Phillips" wrote:
>
> > In the VBIDE window (Ctrl-G), just type the macro names and return, or
> > select them from the Excel app via Alt-F8, and select and run from the
> > list.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Jack R" <jgoose@excel2003.com> wrote in message
> > news:C8C28FE1-3626-46B2-9CE5-E897966FC8A7@microsoft.com...
> > > It has been some years since I needed this application. On an Excel
> > > spreadsheet I need to enter [via VBA Editor] a sequence of 3 macros
which
> > > will activate a "running total" in each cell. I have the code, but
not
> > sure
> > > how to enter [type] in the Editor page.
> > > --
> > > WJR
> >
> >
> >