Ready to Learn More

Microsoft Excel VBA Macro Coding

Who Should Attend

Those who work with Microsoft office products (particularly Excel) on a daily basis and wish to use Excel more efficiently and provide complex tasks in an easy to use manner for their work, colleges and other staff. 


Whether you like to enhance your performance by being able to understand the codes or start a VBA Programming Career this course is ideal for you. You will have the opportunity to familiarize yourself with creating macros to automate tasks and learn some important concepts and techniques which will enable you to create and improve your codes to make macros more efficient.


An excellent knowledge of any MS-Excel (2016, 2013, 2010, 2007 or 2003)


What Will You Learn?

• Check Your Security Settings
• Referring to Objects and Properties
• Get VBA code into VBA module
• Examining the Macro
• Different File Formats
• Saving Workbooks that Contain Macros
• Creating a Module – Declarations – Sub Procedures – Function Procedures
• Some Real Live Codes
• Run Macros to Automate your tasks
• Using Macro Recorder
• Simplifying Object Reference and Fully Qualified Reference
• Work with Values, Offsetting, Counting, Deleting and Message Boxes in VBA
• Object Methods
• VBA Sub and Function Procedures
• Work with SumIf, Copy, Paste, Clear, Date and Length of Name
• Recording in Absolute and Relative Mode
• Using Variables, Constants, and Data Types
• Understanding variables
• Declaring and scoping variables
• Variable Scopes
• Work with For Next and Else, Insert Date and Time Automatically,
• VBA’s Logical Operators
• Working with Range Objects
• Some Useful Range Object Properties
• Some Useful Range Object Methods
• Using VBA and Worksheet Functions
• Using Built-In VBA Functions
• Using a lookup function
• Loop Concept
• While Loop
• For Loop
• For Loop with Dynamic Variable
• User Forms - Introduction
• User Forms - Adding Code to controls of User Forms and improving Macros
• Create and use Buttons for your Macros


One full day (9 am to 5 pm)


Please contact OptionTrain (416)486-6555 or