VBA for MS Excel (Two Days)

  • Getting started with macros
    • Record and run macro
    • Use absolute and relative references
    • Use the personal macro workbook
    • Copy a macro module to another workbook
    • Assign a macro to an object, graphic, or control
    • Add macros to the Quick Acess Toolbar
    • Macro security
  • Getting started with procedures
    • Begin with a code module
    • Create a procedure
  • Understanding Excel objects
    • Object properties
    • Object methods
    • Use the object browser
  • Controlling cells, worksheets, and workbooks
    • Work with cell related objects
    • Automate worksheet and workbook operation
    • appy formatting
  • Working with dialog box
    • Create a custom message box
    • Create a custom input box
  • Using conditional statements to make decisons
    • Use If Then statement
    • Use Select Case statement
  • Using loops to repeat code
    • Use For Next statement
    • Use For Each...Next statement
    • Use Do...Loop statement
  • Working with variables
    • Data type for VBA variables
    • Declare and name variables
  • Debugging and error handling
    • Use debug window
    • Break mode
    • Handle run time error
  • Writing user-defined functions
    • Customize a function procedure
    • Sample function to calculate salary
  • Creating custom form
    • Add a new user form object
    • Use the Toolbox toolbar
    • Use command button to take action
    • Use checkbox and toggle button to set defaults
    • Do calculation analysis by form inputs
    • Other commonly used controls