Excel 2019 Power Programming with VBA

Excel becomes far more adaptable when you can program the work behind the worksheet. Excel 2019 Power Programming with VBA explores how to use Visual Basic for Applications to create and extend spreadsheet applications, moving from core programming concepts to the features that make an Excel solution feel like a finished tool.

Build a foundation in Excel VBA 💻

The opening section introduces spreadsheet application development and the essentials of VBA, including programming fundamentals, Sub procedures, Function procedures, events, and practical examples. This progression gives readers a route from understanding the language to seeing how it can respond to the way a workbook is used.

Put advanced Excel features to work

Later chapters apply VBA to pivot tables and charts, interaction with other applications, and work with external data and files. These subjects show how Excel programming can reach beyond a single cell or routine and support broader, connected tasks.

Create more interactive applications

A dedicated section covers custom dialog boxes and UserForms, from introductory concepts through examples and more advanced techniques. The book then turns to developing Excel applications with add-ins, Ribbon customization, shortcut menus, and help for users.

A practical reference for developing with Excel

With its four-part organization, the book links programming fundamentals to concrete Excel application features. Readers can follow the topics in sequence or use the chapter structure to return to a particular area as their projects call for it.

Who may find it useful

Wiley positions this title for intermediate to advanced Excel users looking to improve their spreadsheet programming skills. It is a relevant choice for developers, analysts, and experienced users interested in building VBA-powered tools, automating workbook tasks, or making Excel applications more interactive.