Basic VBA Topics

  1. Introduction to VBA
  2. Working with Range Dynamically.
  3. Data Type and Variable
  4. InputBox
  5. MsgBox
  6. If Statement
  7. Working with WorkBooks
  8. Working with Worksheets
  9. For Loop
  10. VBA Function
  11. Excel Function in VBA
  12. Formating in VBA
  13. Filter
  14. PivotTable
  15. Dialog Boxes
  16. Error Handling
  17. For Each Loop
  18. FSO
  19. NotePad Automation
  20. OutLook Automation
  21. User Form Automation

Adv VBA topics

  1. Array
  2. Working with Charts
  3. Working with Shapes
  4. UDF
  5. Connection with Other Application
  6. PowerPoint Automation
  7. Regular Expression (Working with Pattern)
  8. Add-Ins (User Define)
  9. Creating MenuBar
  10. Creating CommandBar
  11. Creating ToolBar
  12. Working with Collection
  13. Working with Dictonary
  14. MS Word Automation with Excel
  15. Early Binding and late Binding
  16. Automating In-build features

Adv Function

  1. Offset
  2. Resize
  3. Split
  4. Union
  5. Format
  6. Environ

Basic Function

  1. Left
  2. Right
  3. Mid
  4. Ucase(Upper)
  5. Lcase(Lower)
  6. IsError
  7. IsEmpty
  8. IsNumeric
  9. IsNull

Other Function

  1. Switch
  2. DateDiff
  3. Replace
  4. WeekDay
  5. Rnd
  6. Round
  7. Dir
  8. Instr
  9. Instrrev

ExcelVBATips is a group of professionals, Managed by Chetna Sharma. Please whatApp us 8285052214 for more information or email us on ExcelVBATips@gmail.com.