Correct coding entry of VBA macros in Excel worksheet

[Guest]

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.

 

[Bob Phillips]

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)

 

[Guest]

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

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)

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.

 

[Bob Phillips]

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)

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

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)

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.