
Quick Reference: How to integrate macros into Excel
====================================================================================================================================
Standard Macro
Copy the code in the post
Open Excel and the workbook that requires the code
Press ALT+F11
From the Insert Menu of the VBA window, select Module
Paste the code onto this new module
Close the VBA window
In Excel, press ALT+F8
Select the macro you pasted from the list
Click Run
For a more detailed process (with screen shots) to integrate you macro, see this page.
Or see step by steps at Contextures: Excel VBA -- http://www.contextures.com/xlvba01.html" onclick="window.open(this.href);return false;
Sheet/Workbook Event Macro
Copy the code in the post
Open Excel and the workbook that requires the code
Right click on the sheet tab on which the macro should run
Select View Code
Paste the macro on the module that appears on the right
(For a Workbook Event Macro – Double click on This Workbook in the projects window and paste code on this)
Close the VBA window
The macro will now run in the sheet based on the trigger event
For a more detailed process (with screen shots) to integrate you macro, see this page.
Or see step by steps at Contextures: Excel VBA -- http://www.contextures.com/xlvba01.html" onclick="window.open(this.href);return false;
====================================================================================================================================
VBA Online Tutorials (FREE)
There are good books that you can purchase, but there is a wealth of free tutorials on the web that can give you a good introduction into VBA. If you work through some of these tutorials and put into practice what you learn, you will very quickly get the just of coding in Excel. It's really just a matter of "playing" with the code, recording macros and learning of the objects and hierarchies and exercise.
Start with these online tutorials:
-- http://www.homeandlearn.org/index.html" onclick="window.open(this.href);return false;
-- http://excelvbatutor.com/vba_tutorial.html" onclick="window.open(this.href);return false;
-- http://www.excel-easy.com/vba.html" onclick="window.open(this.href);return false;
-- http://www.excel-vba.com/excel-vba-contents.htm" onclick="window.open(this.href);return false;
-- http://www.excel-pratique.com/en/vba.php" onclick="window.open(this.href);return false;
-- http://www.anthony-vba.kefra.com/vba/vbabasic1.htm" onclick="window.open(this.href);return false;
VBA Books
You cannot go wrong with John Walkenbach's books. They are very good, and there is a wide selection from intro's to Excel and VBA to high end programming in VBA, tips and tricks books, the Excel Bible, Excel for Dummies and books focusing only on formulas. I'd definitely start there if you want an actual "hand held" book. See this page for a listing of his books, and here on his website...
Excel Online Tutorials (FREE) and YouTube Videos
See: Microsoft's Official Excel Online Training Site
and: Learn Excel Without Spending a Penny: 40 Free Excel Tutorials & Reference Sites
and: Free Online Education: Word & Excel Training
and: http://www.gcflearnfree.org/excel" onclick="window.open(this.href);return false;
and: Excel Exposure
and: Wise Owl VBA Tutorial Videos
====================================================================================================================================
Additional Resources
Offline help for VBA in the Office 2013 applications.
Download: Download Office 2013 VBA Documentation.
What is a Visual Basic Module?
http://www.emagenit.com/VBA%20Folder...vba_module.htm" onclick="window.open(this.href);return false;
Writing VBA Function in Excel
http://office.microsoft.com/en-us/ex...117011033.aspx" onclick="window.open(this.href);return false;
http://www.exceltip.com/st/Writing_Y...Excel/631.html" onclick="window.open(this.href);return false;
User Form Creation
http://www.contextures.com/xlUserForm01.html" onclick="window.open(this.href);return false;
Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
http://www.cpearson.com/Excel/vbe.aspx" onclick="window.open(this.href);return false;
Excel 4 Macro Help in .CHM Format
File and quoted description below supplied by our very own AlanMiller
There is occasionally a reference made to Excel 4 macros. The old help file for these is in the Windows .HLP format, which requires a special viewer on modern Windows versions. The link below contains my own attempt at converting this to a .CHM file. While I think all the contents translated across, some organization features are lost. If there is a demand, I can redo it more thoroughly.
Download the file here.
Useful VBA Add-Ins
MZTools 3.0 (VBA Enhancer): http://www.mztools.com/v3/mztools3.aspx" onclick="window.open(this.href);return false;
Rob Bovey's VBA Code Cleaner: http://www.appspro.com/Utilities/CodeCleaner.htm" onclick="window.open(this.href);return false;
Smart Indenter (Auto Indent Code Blocks): http://www.oaltd.co.uk/indenter/indentpage.asp" onclick="window.open(this.href);return false;
Useful Excel Add-Ins
Name Manager by Jan Karel Pieterse: http://www.jkp-ads.com/officemarketplacenm-en.asp" onclick="window.open(this.href);return false;
XY Chart Labeler by Rob Bovey: http://www.appspro.com/Utilities/ChartLabeler.htm" onclick="window.open(this.href);return false;
Filter Highlighter by Rory: HiLite Filter
Generate Random Test Data: Eileen’s Random Data Generator
ASAP Utilities for Excel: http://www.asap-utilities.com/" onclick="window.open(this.href);return false;
=======================================
See this thread for links to Word Resources: