Excel VBA Introduction (2-Day Classroom-based course)

Event Description

30th & 31st January 2023 – Introduction to Excel VBA (2-Day course), taking place at our Belfast City Centre Training Suites, from 9:30am to 4:30pm…

#excelvba #belfast #practicaltraining #interactivelearning #Microsoft #inpersontraining

PREREQUISITES
• A high proficiency of Microsoft Excel is essential, or completion of our 2 day Advanced MS Excel course.

BENEFITS
At the end of the course the delegate will have covered the fundamentals of VBA, including:
• working with procedures and functions
• understanding objects
• using expressions, variables and intrinsic functions.

COURSE CONTENT

INTRODUCTION
• What is a Macro
• Recording a Macro
• Relative References
• Running A Macro
• Running A Macro From The Macros Dialog Box
• Editing A Macro With Visual Basic

ASSIGNING MACROS TO BUTTONS AND OBJECTS
• Assigning a Macro to a Button on a Sheet
• Assigning a Macro to a Drawn Object on a Sheet
• Creating A Short-Cut Key To Run A Macro

VISUAL BASIC EDITOR
• Objects
• Methods
• Properties
• Programming Tools
• The Menu Bar

EDITING MACROS
• The Visual Basic Editor
• The Project Explorer
• The Code Window
• Procedures
• Inserting Comments
• Printing a Visual Basic Module

THE RANGE OBJECT
• The Cells Property
• The Range Property

WORKBOOKS AND SHEETS
• Activating a Workbook
• Activating a Worksheet
• ThisWorkBook
• Running Code
• Run Mode And Design Mode
• Running Code From The Development Environment

THE PROJECT EXPLORER
• Using The Project Explorer

THE PROPERTIES WINDOW
• Changing A Property

USING CONSTANTS
• Excel Constants
• Variable Constants

EXCEL OBJECTS
• Objects, Properties And Methods
• Getting & Setting Properties

VARIABLES
• Using Variables In Routines

USING BASIC FUNCTIONS
• Inputbox Function
• Msgbox Function
• Using A Set Statement

#contactusformoreinfo
T: +44(0)28 90 322 228
E: info@mullanittraining.com
W: www.mullanittraining.co.uk

Register for Event