Microsoft Excel

VBA and MACROS

  1. Absolute and Relative Macro Recording
  2. VBA Editor (VBE)
  3. VBA Data Types
  4. VBa Data Types Examples

Excel Add-ins

EVENT PROCEDURES

  1. Worksheet Events
  2. Workbook Events
  3. Application Events
  4. Chart Events

User Defined Functions

VBA LOOPS

  1. For Each … Next Loop
  2. Do While Loop
  3. Do Until Loop

WORKSHEET EVENTS

  1. Worksheet Activate and Deactivate Events
  2. Worksheet BeforeDoubleClick and BeforeRightClick Events
  3. Worksheet Change and SelectionChange Events
  4. Worksheet Delete, Calculate, FollowHyperlink Events
  5. VBA TableUpdate Event
  6. Worksheet PivotTable Events

WORKBOOK EVENTS

  1. Workbook Activate and Deactivate Events
  2. AddInInstall and AddInUninstall Events
  3. Workbook AfterSave and BeforeSave Events
  4. AfterXmlExport, AfterXmlImport, BeforeXmlExport and BeforeXmlImport Events
  5. Workbook Open and Before Close Events
  6. BeforePrint, ModelChange and NewChart Events
  7. NewSheet Event
  8. Workbook Sheet Events
  9. Workbook PivotTable Events
  10. WindowActivate, WindowDeactivate, and WindowResize Events

APPLICATION EVENTS

  1. Protected View Events
  2. Activating Application Events
  3. Protected View Events
  4. Sheet Events for all available workbooks
  5. Application Pivot Table Events
  6. XML Events for Application Object
  7. Window Events for Application Object
  8. Workbook Activate, Deactivate, AfterCalculate Application Events
  9. Application Workbook Addins Events
  10. Workbook Sync and Remote Change Application Events
  11. Workbook Open, Close, Save Events for Application Object
  12. Workbook Printing and Model Change Events for Application Object
  13. New Workbook, New Sheet, New Chart Application Events

CHART EVENTS

  1. Inserting Chart Sheet
  2. Chart Activate, Deactivate, Resize and Calculate Events
  3. Chart Select (single click), Double Click, and Right Click Mouse Events
  4. Chart MouseDown, MouseMove and MouseUp Events
  5. How to use events with an embedded chart

OnTime Event: Schedule a macro or subroutine

  1. OnUndo method to Undo a procedure or macro
  2. OnRepeat: Run a sub when user chooses Repeat command
  3. OnKey Event: Make shortcut keys using VBA

Using XML with Excel

  1. Import XML Documents
  2. Export Data to XML Document