🏡

VBA for Programmer

Course Outline Outline
Reading Material
Introduction Intro-VBA003.pptx
DAYTopicsSharing
1
  • Modular and Event Driven Concepts
  • Modules
  • Class Model
  • User Form
  • Document Model
  • When to use which?
  • Return value from function
  • Termination
  • Macro: A special form of Sub
  • Event handler: A special form of Sub
  • Multi-Dimensional Array
  • LBound and UBound functions
  • Redim
  • Redim Preserve
  • Variant
  • Using Type
  • Object
  • Predefined Constants
2
  • On Error
  • On Error Goto
  • On Error Resume Next
  • Dealing with events
  • Event Parameters
  • Event Handlers
  • Worksheet Events
  • Workbook Events
  • Re-Entrant Issue
  • Button
  • CheckBox
  • Radio Button
  • ComboBox and ListBox
  • ScrollBar
3
  • The purpose
  • How to Declare?
  • How to call it?
  • The Purpose
  • Properties Declaration
  • How to use it?
  • Using Declare keyword to extend VBA ability using external DLL
  • Advanced Techniques
  • Security Concerns
  • Common Pitfalls
  • Good Practices

Recommanded Books
TitleVBA Automation for Excel 2019 Cookbook-Solutions to automate routine tasks and increase productivity with Excel
ISBN978-1-789-61003-1
AuthorVan Niekerk, Mike
Year2020
Publisher Published by Packt Publishing Ltd.
TitleMicrosoft Excel 2019 VBA and Macros
ISBN978-1-509-30611-4
AuthorBill Jelen, Tracy Syrstad
Year2019
Publisher Microsoft Press
TitleMastering VBA 2019-For Microsoft Office 365, 2019 Edition
ISBN978-1-119-57933-5
AuthorRichard Mansfield
Year2019
Publisher Sybex Inc
TitleExcel 2019 Power Programming with VBA
ISBN978-1-119-51492-3
AuthorMichael Alexander, Richard Kusleika
Year2019
Publisher Wiley
TitleExcel VBA Programming for Dummies
ISBN978-1-119-51817-4
AuthorJohn Walkenbach
Year2018
Publisher Wiley
TitleProgramming Excel with VBA-A Practical Real-World Guide
ISBN978-1-484-22204-1
AuthorFlavio Morgado
Year2016
Publisher Apress
TitleExcel VBA 24-Hour Trainer
ISBN978-1-118-99137-4
AuthorTom Urtis
Year2015
Publisher Wrox