120 likes | 424 Views
Excel VBA Class. Glenn Harris Microsoft Certified Trainer Office Master Instructor Excel Class NYC. Lesson 0 – Programming Logic. Fundamentals of Programming. Macros. Strengths/Weaknesses How To Record A Macro How To Edit A Macro How To Debug A Macro. The VB Editor. VB Editor Menus
E N D
Excel VBA Class Glenn Harris Microsoft Certified Trainer Office Master Instructor Excel Class NYC
Lesson 0 – Programming Logic • Fundamentals of Programming
Macros • Strengths/Weaknesses • How To Record A Macro • How To Edit A Macro • How To Debug A Macro
The VB Editor • VB Editor Menus • VB Editor Toolbars • VB Editor Panes
Fix Macros • Declare Variables • Variable Substitution • Variable Concatenation • Get The Name Of The Activesheet
Writing VBA Programs • Pseudocode • Navigate Cells/Sheets With VBA • Add/Name Sheets With VBA • Find The Last Row • Looping Control Structures • If/Then Control Structures • More Debugging
VBA Formulas, Functions and Dialogs • MessageBox Intrinsic Function • InputBox Intrinsic Function • Write A Function To A Cell • Perform A Function Call In Memory • Write Your Own Functions • Workbook Events • Range Intersections • Macros That Call Other Macros And Pass Variables
VBA Forms • Insert A Form • Add Form Controls • Labels • Text Boxes • Drop Down List Boxes • Checkboxes • ActiveX Controls
Object Variables • Data Tables/Array Formulas • Named Ranges • Object Variables • More Looping Control Structures