This course covers Excel Macro Recording and Coding Excal VBA. For Excel users. Extend the capabilities of Excel with Macros and VBA code.
Excel Macros and VBA Course summary
For Excel users. Extend the capabilities of Excel with Macros and VBA code.
Outline:
Record simple Excel macros with shortcuts or buttons
Setting Excel Macro Options
Record and Run Macros
The Quick Access Toolbar
Excel VBA Editor
Use the VBA Editor
Create, copy and import/export modules
Starting the Visual Basic Editor, Use Project Explorer
Creating Procedures and Functions
Create macro procedures in code using variables
Creating Sub and Function Procedures
Declare and Use Variables
Displaying Messages
Getting Input from the User
Controlling Program Flow
IF Statement
Select Case Statement
For Next Loops and Do Loops
Interacting with a spreadsheet :
Referencing Cells and Ranges
Gathering Cell and Range Information
The Offset Method
With Blocks
Referencing Workbooks and Worksheets
Functions
Standard Excel Functions in VBA
Custom functions
Calling functions and sub procedures
User Forms
Basic design, display and interaction with forms
PCWorkshops deliver's computer programming, database and data visualization courses to companies of all industries and sizes in city centers near our locations.
Our head-quarters are in London.
We customize programming courses and query development courses on request per company.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy