Workshop on

Microsoft Excel 2007/2010 Macro and VBA Made Easy
 
Held on : 06 - 07 July 2012
 
Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
 
No. of Participants : 25
 
 
No photos found
 

Course Description
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
 

Resource Person
Abu Shams Mahmood Arif

Mr. Shams has been working in a leading multi-national bank for several years. His extensive work experiences are in Business Analytics & MIS, Process Re-engineering & Automation, Business Research & Development and Project Management.
He has graduated from North South University. After that he completed his MBA. His major accomplishments and contributions are Business Operations Analytics, BOLD (Six Sigma Initiative), CBS (Core Banking System), BEFTN (Bangladesh Electronic Fund Transfer Network).

He has been a reputed public and corporate trainer for several years on subjects like Management Information System(MIS), Financial Analysis & Modeling, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.
Mr. Shams also has experiences in Oracle, MySQL, SQL Server, ASP.Net, PHP, HTML, Flash, Ruby on Rails and Cisco networking.