About Workshop
Introduction
Microsoft Excel is most widely used productivity tool in today’s corporate world and education sector. Day to day corporate analysis and tools are prepared with Excel. Macros & VBA are advanced features of MS Excel for developing business tools and applications. It will be an advantage for course attendees to learn practical and advanced usages of Excel Macros & VBA for office and academic activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.
How participants will benefit after the course
HANDS ON EXPERIENCES. Each widely practiced Excel Macro & VBA topics are covered in the course syllabus with practical exercises. Working with Macros, Visual Basic Editor, Command Bars & Buttons, Modules, Function and Subroutines, Excel Object Model, VBA Programming, Debugging, Error Handling, UserForm, and other required functionalities of this course will ensure participants high performance in their career and academics.
Methodology
PRACTICAL. The course is designed for practical applications at works along with theoretical notes for after course practices and references. Participants will go through with examples that they can relate to their office or educational works.
Workshop topics to be covered:
Working with Macros
o Difference between Macros and VBA
o Record and run a macro.
o Understand and edit simple recorded macros
o Run a macro by using a shortcut key
o Creating and managing PERSONAL.XLSB
o Running Macros using Buttons
o Running Macros When a Workbook Is Opened
o Manage macro security
o Trusting Macro-enabled Workbooks
Visual Basic Editor
o Understanding VBE components
o Working with the Project Window
o Adding a new VBA module
o Exporting and importing objects
o Creating a module
o Using the Editor tab
o Using the General tab
o Using the Docking tab
Command Bars & Buttons
o CheckBox
o ComboBox
o Command Button
o Label
o ListBox
o OptionButton
o TextBox
VBA Comments
Modules, Function and Subroutines
o Modules
o Difference Between Subroutines and Functions
o Writing a Simple Subroutine
o Writing a Simple Function
o Public and Private Functions and Subroutines
o Argument Data Types
o Optional Arguments
Excel Object Model
o Properties
o Methods
o Events
o Main Objects
MsgBox & Input Box
VBA Programming
o Variables
o Data Types
o VBA Data Types
o Arrays
o Reserved Words
o String Manipulation
o Program Flow & Decisions Looping
o Operators
o Functions
Debugging
o Types of Errors
o Design Time, Runtime, and Break Mode
o Breakpoints
o Using Stop Statements
o Running Selected Parts of Your Code
Error Handling
o The Resume Statement
o Implications of Error Trapping
UserForm
o When to Use a UserForm
o Inserting a new UserForm
o Adding controls to a UserForm
o Changing properties for a UserForm control
o Viewing the UserForm Code window
o Displaying a UserForm
o Using information from a UserForm
Macro & VBA Examples
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
