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