G Guest Nov 23, 2005 #1 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.
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.
C Chip Pearson Nov 23, 2005 #2 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
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
B Bob Phillips Nov 23, 2005 #3 Select the code on the web page, and then copy it Ctrl-C. In Excel, go to the VBIDE (Alt-F11), and menu Insert>Module, then paste the code (Ctrl-V) there. -- HTH RP (remove nothere from the email address if mailing direct)
Select the code on the web page, and then copy it Ctrl-C. In Excel, go to the VBIDE (Alt-F11), and menu Insert>Module, then paste the code (Ctrl-V) there. -- HTH RP (remove nothere from the email address if mailing direct)