Part VIProgramming Excel with VBA

If you've ever wanted to automate routine operations so that you don't always have to perform boring, repetitious tasks manually, this part is for you. This part is also aimed at those Excel users who want to develop Excel-based applications for other users. Visual Basic for Applications (VBA) is the powerful programming language that you can use for these tasks, as well as for more esoteric purposes, such as developing that specialized worksheet function that you simply can't find in Excel.

In This Part

  1. Chapter 39Introducing Visual Basic for Applications
  2. Chapter 40Creating Custom Worksheet Functions
  3. Chapter 41Creating UserForms
  4. Chapter 42Using UserForm Controls in a Worksheet
  5. Chapter 43Working with Excel Events
  6. Chapter 44VBA Examples
  7. Chapter 45Creating Custom Excel Add-Ins

Get Excel 2016 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial