Excel 2013 VBA (CDROM)

by Dr. Gerard M. Verschuuren


Published by Holy Macro Books! Uniontown, OH

Order the CDROM from MrExcel: www.MrExcel.com
Order the CDROM from Amazon: www.Amazon.com


Module 1:Basic Essentials
	Object  Oriented
	Recording Macros
	Branch Statements
	Interaction
	Variables (Value Type)
	Variables (Object Type)
	Collections
	Loop Statements
	Variables as Arguments
	Pivot Tables and Charts
 
Module 2: Formulas and Arrays
	Dates and Calendars
	The Current-Region
	Property WorksheetFunction
	Property Formula
	Property FormulaR1C1
	Custom Functions
	Array Functions
	1D- and 2D-Arrays
	Customized Arrays
	Variant Arrays
 
Module 3: Buttons, Forms, and More
	Importing and Exporting
	Buttons, Bars, Menus
	Application Events
	User Forms
	Data Entry + Mail Merge
	Custom Objects (Classes)
	Class Collections
	Error Handling
	Distributing VBA code
	VBA Monitoring VBA