Advanced VBA Programming

Course Outline 🔗Outline
Reading Material
Introduction 🔗Intro-VBA005.pptx
DAYTopicsSharing
1
  • Concepts
  • Naming Conventions
  • Best Practices for Application Structure and Organization
  • General Application Development Best Practices
  • Principles of Good Worksheet UI Design
  • Program Rows and Columns: The Fundamental UI Design Technique
  • Defined Names
  • Styles
  • User Interface Drawing Techniques
  • Data Validation
  • Conditional Formatting
  • Using Controls on Worksheets
  • The Four Stages of an Application
  • Function Library Add-ins
  • General Add-ins
  • Application-Specific Add-ins
Training Materials: Useful References:
2
  • Structure of a Dictator Application
  • Creating Objects
  • Creating a Collection
  • Trapping Events
  • Raising Events
  • Command Bar Design
  • Table-Driven Command Bars
  • Putting It All Together
  • Loading Custom Icons from Files
  • Hooking Command Bar Control Events
  • The RibbonX Paradigm
  • Ribbon Design and Coding Best Practices
  • Table-Driven Ribbon UI Customization
  • Advanced Problem Solving
  • Command Bar and Ribbon User Interfaces in a Single Application
  • Other Excel Development Issues
  • Windows Security and Folder Structure
  • Overview
  • Working with the Screen
  • Working with Windows
  • Working with the Keyboard
  • Working with the File System and Network
Training Materials: Useful References:
3
  • Principles
  • Control Fundamentals
  • Visual Effects
  • UserForm Positioning and Sizing
  • Wizards
  • Dynamic UserForms
  • Modeless UserForms
  • Control Specifics
  • What Is an Interface?
  • Code Reuse
  • Defining a Custom Interface
  • Implementing a Custom Interface
  • Using a Custom Interface
  • Polymorphic Classes
  • Improving Robustness
  • Simplifying Development
  • A Plug-in Architecture
  • Measuring Performance
  • The PerfMon Utility
  • Creative Thinking
  • Macro-Optimization
  • Micro-Optimization
  • An Introduction to Databases
  • An Introduction to SQL
  • Data Access with ADO
  • Designing the Data Access Tier
  • Working with Microsoft Access Databases
  • Working with Microsoft SQL Server Databases
  • Upsizing from Access to SQL Server
  • Excel's Data Structures
  • Data Processing Features
  • Advanced Functions
  • Fundamental Techniques
  • VBA Techniques
Training Materials: Useful References:

Recommanded Books
TitleExcel Revolution: Python with VBA in Excel: A comprehensive Guide For The Year 2024
ISBN979-8-873-77946-8
AuthorStrauss, Johann; Van Der Post, Hayden
Year2024
Publisher Reactive Publishing
TitleVlookup Viking: The Ultimate Guide for Excel Warriors
ISBNB0CRPZ6RTD
AuthorSampson, Josh; Van Der Post, Hayden; Strauss, Johann; Bissette, Vincent
Year2024
Publisher Reactive Publishing
TitleThe Art of VBA Mastery: A Cureated Expert Guide For VBA In Finance
ISBNB0CRT9X9G9
AuthorStrauss, Johann; Bisette, Vincent; Van Der Post, Hayden
Year2024
Publisher Reactive Publishing
TitleMaster the Art of Automation: A Comprehensive VBA Guide for Finance & Accounting
ISBNB0CRT56LHZ
AuthorSampson, Josh; Strauss, Johann; Van Der Post, Hayden
Year2024
Publisher Reactive Publishing
TitleExcel and VBA Boosting Performance with Best Practices
ISBN979-8-223-17133-1
AuthorAmerico Moreira
Year2023
Publisher Americo Moreira
TitleThe Ultimate Guide To Microsoft Excel Vba For Beginners And Seniors
ISBN979-8-215-36434-5
AuthorMike Cage
Year2023
Publisher Bluerose Publising
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