€495
VBA with Microsoft Excel (v1.1)

VBA with Microsoft Excel (v1.1)

Actions and Detail Panel

€495

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
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

Share with friends

Date and time

Location

Online event

Save This Event

Event Saved