VISUAL BASIC FOR APPLICATIONS – 3 DAYS (CAN BE SHORTENED)

Prerequisites:

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.

Course Overview

This course will teach you how to automate repetitive tasks in Excel by recording macros. You will learn how to edit and string macros.

You will then learn how to write a code in the Visual Basic Editor. Controls worksheets, workbooks and create message boxes. You will also learn about creating User Forms, custom functions, conditional statements, events and looping over instructions.

VBA Course Topics

1. Record A Simple Macro
2. Record a Macro
3. Run a Macro
4. Understand the VB Editor
5. Use the Menu Bar
6. Use the Standard Toolbar
7. Use the Project Explorer
8. Use the Properties Window
9. Understand the Code Window
10. Understand Code Window Options
11. Edit Code
12. Get Help
13. Use .CHM or .HLP Files
14. Close the Visual Basic Editor
15. Work with Objects
16. Understand the Object Browser
17. Understand Objects
18. Understand the Objects Hierarchy
19. Reference Objects
20. Understand Collections
21. Use the Editing Features
22. Use the Immediate Window
23. Use the Auto List
24. Use Auto Quick Info
25. Work with Variables
26. Understand Variables
27. Declare Variables
28. Understand Data Types
29. Store Values in Variables
30. Store Objects in Variables
31. Create Procedures and Functions
32. Understand Procedures
33. Use the Macro Recorder to Create Sub Procedures
34. Call Procedures from Procedures
    
35. Use Intrinsic Functions
36. Use Message Boxes
37. Use Input Boxes
38. Create Functions
39. Pass Arguments to a Function
40. Work with Conditional Statements
41. Understand Conditional Statements
42. Work with Decision Structures
43. Work with Loop Structures
44. Work with Forms and Controls
45. Understand Userform
46. Use the Toolbox
47. Work with Userform Properties
48. Events and Methods
49. Use the Properties Window
50. Understand Controls
51. Work with the Label Control
52. Work with the Text Box Control
53. Work with the Command Button Control
54. Work with the Combo Box Control
55. Work with the Frame Control
56. Work with the Option Button Controls
57. Add Functionality to Forms
58. Work with Control Appearance
59. Set the Tab Order
60. Populate a Control
61. Add Code to Controls
62. Launch Forms from Procedures
63. Use Pivot Tables
64. Understand PivotTables
65. Create PivotTables
66. PivotTable Arguments
67. Add Fields to PivotTables
68. Control Forms
69. Control Pivot Tables from a Form
70. Control a Form from a Custom Toolbar
71. Understand Debugging
72. Understand Errors
73. Debug Code
74. Debug Tools
75. Use the Locals Window
76. Use the Watch Window
77. Use Breakpoints
78. Create Add-in