ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copying vba code to a standard code module (https://www.excelbanter.com/excel-discussion-misc-queries/56960-copying-vba-code-standard-code-module.html)

1vagrowr

copying vba code to a standard code module
 
How do I copy vba code from a web page to a standard code module? Note: I
don't know what a standard code module is.

Thanks.

Chip Pearson

copying vba code to a standard code module
 
In the VBA editor, go to the Insert menu and choose Module. Cut
and paste the code from the web page to that module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"1vagrowr" wrote in message
...
How do I copy vba code from a web page to a standard code
module? Note: I
don't know what a standard code module is.

Thanks.




Bob Phillips

copying vba code to a standard code module
 
Select the code on the web page, and then copy it Ctrl-C.

In Excel, go to the VBIDE (Alt-F11), and menu InsertModule, then paste the
code (Ctrl-V) there.

--

HTH

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


"1vagrowr" wrote in message
...
How do I copy vba code from a web page to a standard code module? Note: I
don't know what a standard code module is.

Thanks.





All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com