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

Correct coding entry of VBA macros in Excel worksheet
 

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" wrote in message
...
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

Correct coding entry of VBA macros in Excel worksheet
 

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" wrote in message
...
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

Correct coding entry of VBA macros in Excel worksheet
 

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" wrote in message
...
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" wrote in message
...
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