VBA with Microsoft Excel (v1.1)
Date and time
Location
Online event
Refund policy
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the
About this event
1 - USING VBA TO SOLVE BUSINESS PROBLEMS
Use Macros to Automate Tasks in Excel
Identify Components of Macro-Enabled Workbooks
Configure the Excel VBA Environment
2 - RECORDING A MACRO
Use the Macro Recorder to Create a VBA Macro
Record a Macro with Relative Addressing
Delete Macros and Modules
Identify Strategies for Using the Macro Recorder
3 - WRITING VBA CODE DIRECTLY
Write VBA Code
Discover Objects You Can Use
Create a Custom Function
4 - SOLVING PROBLEMS THROUGH CODE
Make Decisions in Code
Work with Variables
Perform Repetitive Tasks
5 - IMPROVING YOUR VBA CODE
Debug VBA Errors
Deal with Errors
Improve Macro Performance
6 - CONTROLLING HOW AND WHEN MACROS RUN
Prompt the User for Information
Configure Macros to Run Automatically