Excel Macros (VBA) Course Details

Macros

• Understanding Macros
• Storing Macros
• This Workbook
• Personal Macro Workbook
• New Workbook
• Recording a Basic Macro
• To record a macro
• Relative References
• To set the reference type
  Running a Macro
• To run a macro automatically when you open a file
• Invoking Macros
• Macros can be invoked (run) from a number places:
• To run a macro from the keyboard
• To run a macro from the menu
• Editing and Deleting Macros
• To edit a macro
• To delete a macro
• Assigning a Macro to a Toolbar or Menu
• To assign a macro to a menu or toolbar
• Button Image Editor
• To edit a button image
• To display the button image
• Macro Virus Protection
• To change the security levels
• The Visual Basic Editor Window
• Visual Basic Editor Layout
• Standard Toolbar
• Object Box
• Procedure Box
• Project Explorer
• Properties Window
• The Visual Basic Editor
• Procedures
• Function Procedures
• Object Oriented Programming (OOP)
• Objects
• Properties
• Methods
• Variables
• Data Types
• List of Data Types

• Expressions
• Operators
• Constants
• Functions
• Arguments
• DECLARING VARIABLES
• Dim Statement
• Private Statement
• Public Statement
• Static Statement
• Option Explicit
• Working with Objects
• Property Values
• Visual basic Properties
• Returning a Property Value
• Object Methods
• Other Common Methods
  Using Operators in Expressions
• Concatenation (&)
• Logical Operators
• The Is Operator
• The Like Operator
• User Defined Functions
• User Interaction Dialogue Boxes
• InputBox Function
• MsgBox Statement
• Program Flow Commands
• Decision Making Commands
• · If … Then
• Repeat (Looping) Commands
• The If … Then
• The If … Then … Else … End If Structure
• The If … Then … ElseIf … End If Structure
• The Nested If Structure
• The Select Case … End Select Structure.
• The Do …While Loop
• The Do …Until Loop
• The For … Next Loop4
• Handling Run Time Errors
• User Forms (Custom Dialogue Boxes)
• Adding Controls to a Custom Dialogue Box
• Practical Usage of Macros
• STAGE 1 Setting Up The Spreadsheet
• STAGE 2 Setting Up The Input Area
• STAGE 3 Writing The Macro to Accept Data Entry
• STAGE 4 Transferring The Input To The Spreadsheet
• STAGE 5 Error Trapping
  Dealing with dates
• Dialogue Boxes