100 Best VBA Books of All Time

We've ranked the best vba books using expert recommendations, sales data, and millions of reader ratings. At Shortform, we know books. Our book guides are the best in the world. Learn why.

Access 2019 Bible book cover1

Access 2019 Bible

Michael Alexander

5.0
Master database creation and managementAccess 2019 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need t
2

Excel 2016 Power Programming with VBA

Michael Alexander and Richard Kusleika

4.9
Maximize your Excel experience with VBAExcel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (Addison-Wesley Microsoft Technology) book cover3

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (Addison-Wesley Microsoft Technology)

Rob Bovey, Dennis Wallentin, et al.

4.8
Microsoft Excel can be much more than just a spreadsheet. It has become adevelopment platform in it own right. Applications written using Excel are partof many corporations' core suites of business-critical applications. In spite ofthis, Excel is too often thought of as a hobbyist's platform. While there arenumerous titles on Excel and VBA, until now there have been none thatprovide an overall exp
Microsoft Excel 2013 Power Programming with VBA book cover4

Microsoft Excel 2013 Power Programming with VBA

John Walkenbach

4.7
Maximize your Excel 2013 experience using VBA application development

The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you
5

Excel 2003 Power Programming with VBA

John Walkenbach

4.6
Excel VBA Programming for Dummies book cover6

Excel VBA Programming for Dummies

John Walkenbach

4.6
Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of "Excel VBA Programming For Dummies" introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, yo
7

Excel 2016 Bible

John Walkenbach

4.6
The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the "Excel 2016 Bible" is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the
8

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query

Ken Puls, Miguel Escobar

4.6
Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets
VBA and Macros: Microsoft Excel 2010 book cover9

VBA and Macros: Microsoft Excel 2010

Bill Jelen and Tracy Syrstad

4.6
AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techni
10

Plucking the Low-Hanging Fruit of Excel VBA – Start Coding in 1 Week!

JOHN SOH YONG YE

4.6
11

41 Success Habits for Creating Excel Macros

Paul Kell

4.5
Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP book cover12

Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP

Julitta Korol

4.5
This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web."Microsoft Excel 2013 Programming by Example w
13

Learn Excel 2007 Expert Skills with the Smart Method

Mike Smart

4.5
This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. Here are just five of the many ways in which this book is unique:


The book will equip you with excellent Excel skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace.
Writing Excel Macros with VBA book cover14

Writing Excel Macros with VBA

Steven Roman

4.5
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:

The Visual Basic Editor and the Excel VBA programming environment. Excel features a compl
15

Exploring Arc Objects: Vol. 1 Applications And Cartography (1)

Michael Zeiler

4.5
Excel: The Absolute Beginner's Guide to Maximizing Your Excel Experience for Maximum Productivity and Efficiency With all Formulas & Functions and Practical Examples book cover16

Excel: The Absolute Beginner's Guide to Maximizing Your Excel Experience for Maximum Productivity and Efficiency With all Formulas & Functions and Practical Examples

Henry Skinner

4.5

Ready to Transform Your Excel Skills? Discover Why "Excel 2026" Is the Best-Selling Excel Guide!🌟 EXCLUSIVE BONUSES AWAIT: 7 Hours of Video Tutorials + 5 Ebooks + 200 Templates! 🌟"Excel 2026" is your gateway to advanced Excel capabilities. Dive into transformative content brimming with key functions, formulas, shortcuts, and beyond. Prepare for an unparalleled Excel adventure, bolstered by phenome

Introduction to VBA for Excel book cover17

Introduction to VBA for Excel

Steven C. Chapra

4.5
Learn to program and design user interfaces using Excel 2007. KEY TOPICS: This introductory text explains how to develop programs using VBA within the Microsoft Excel environment. The text does not assume any previous programming experience. The new edition has been revised to bring it up-to-date with the Office 2007 environment. MARKET For students and professionals in General Engineering or Com
The Fast-Track Excel Guide for Busy Professionals: A Step-by-Step System to Master Excel Quickly, Automate Tasks, Use AI Tools, and Apply Proven Shortcuts to Boost Productivity and Career Growth book cover18

The Fast-Track Excel Guide for Busy Professionals: A Step-by-Step System to Master Excel Quickly, Automate Tasks, Use AI Tools, and Apply Proven Shortcuts to Boost Productivity and Career Growth

Halbert Burgess

4.5

Are you ready to finally make Excel your most powerful career tool?Do you want to stop wasting time on confusing tutorials and start mastering Excel in a clear, practical, and fast way?Would you like to use Excel to automate tasks, analyze data, and stand out at work?If you answeredyes to any of these questions, this is the guide you’ve been waiting for.The Fast-Track Excel Guide for Busy Professi

19

Hands-On Financial Modeling with Microsoft Excel 2019: Build practical models for forecasting, valuation, trading, and growth analysis using Excel 2019

Shmuel Oluwa

4.5
20

Excel 2016 VBA and Macros (Includes Content Update Program)

Bill Jelen

4.5
MASTER CORE EXCEL 2016 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize inf
Microsoft Access 2019 Programming by Example with VBA, XML, and ASP book cover21

Microsoft Access 2019 Programming by Example with VBA, XML, and ASP

Julitta Korol

4.5
22

Mastering Excel Macros: FileSystemObject

Mark Moor

4.5
Excel Crash Course for Engineers book cover23

Excel Crash Course for Engineers

Eklas Hossain

4.4

Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of techniques to solve and visualize engineering problems and situations. The boo

VB & VBA in a Nutshell: The Language book cover24

VB & VBA in a Nutshell: The Language

Paul Lomax

4.4
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentat
101 Best Excel Tips & Tricks (101 Excel Series) book cover25

101 Best Excel Tips & Tricks (101 Excel Series)

John Michaloudis, Bryan Hong

4.4

Learn the Best Excel Tips & Tricks Ever:FORMULAS, MACROS (VBA), PIVOT TABLES, FORMATTING, DATA, MICROSOFT OFFICE 365plus Many More!With this book, you’ll learn to apply the must know Excel features and tricks to make your data analysis & reporting easier and will save time in the process.With this book you get the following:✔ 101 Best Excel Tips & Tricks To Advance Your Excel Skills & Save You Hou

26

Excel 2019 All-In-One for Dummies

Greg Harvey

4.4
Make Excel work for you

Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel appli
Microsoft Access 2016 Programming by Example: With VBA, XML, and ASP book cover27

Microsoft Access 2016 Programming by Example: With VBA, XML, and ASP

Julitta Korol

4.4
Updated for Access 2016 and based on the bestselling editions from previous versions, Microsoft Access 2016 Programming by Example with VBA, XML and ASP is a practical how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts
Excel 2010 Power Programming with VBA book cover28

Excel 2010 Power Programming with VBA

John Walkenbach

4.4
All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduct
29

Mastering Excel Macros: Looping (Book 5)

Mark Moor

4.4
Excel Programming: The Ultimate Collection to Learn Excel VBA & Excel Macros Step by Step book cover30

Excel Programming: The Ultimate Collection to Learn Excel VBA & Excel Macros Step by Step

David A. Williams

4.4
Are you tired of doing repetitive tasks on the excel, want shortcuts? Do you make often get boredof repeating those bug and error fixes? Do you ever wish to automate the work you do on excel?

If yes, then you have found the right bundle. This two book bundle covers everything from thebasics of Excel covering macros and other simple techniques to make your life easier and alsocovers Visual Basics fo
Python for Excel: A Modern Environment for Automation and Data Analysis book cover31

Python for Excel: A Modern Environment for Automation and Data Analysis

Felix Zumstein

4.4

While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. In fact, it's the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein--creator of xlwings, a popular open source package for automating Excel with Python--shows experienced Excel users how

32

Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

John Walkenbach

4.4
Offers procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic[registered] for Applications.
Mastering Excel VBA Programming: A Hands-On Guide to Automating Excel and Building Custom Solutions with VBA and Macros book cover33

Mastering Excel VBA Programming: A Hands-On Guide to Automating Excel and Building Custom Solutions with VBA and Macros

Nathan George

4.4

Leverage the full power of Excel automation!This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features.Mastering Excel VBA Programming takes you step-by-step from beginner to expert in Excel VBA. This book starts with the basics,

34

Microsoft Excel 2019 VBA and Macros

Bill Jelen and Tracy Syrstad

4.4
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingl
35

Excel 2013 VBA and Macros

Bill Jelen, Tracy Syrstad

4.4
SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! Use Excel(R) 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe
even weeks. Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro
techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful
and useful.
36

Excel VBA and Macros with MrExcel LiveLessons (Video Training)

Bill Jelen

4.4
37

Access 2016 Bible

Michael Alexander

4.4
Master database creation and management "Access 2016 Bible" is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer. Whether you're new to Access or getting started with Access 2016, you'll find everything you nee
38

Mastering Excel Macros - IF Statements (Book 4)

Mark Moor

4.4
39

Mastering Excel Macros: Object Variables (Book 6)

Mark Moor

4.4
40

Macros de Excel y VBA: Para personas ocupadas: Aprende en poco tiempo a crear macros que hagan el trabajo duro por ti. (Spanish Edition)

Luis Alberto Cruz Orellana

4.3
101 Ready To Use Microsoft Excel Macros (101 Excel Series) book cover41

101 Ready To Use Microsoft Excel Macros (101 Excel Series)

John Michaloudis, Bryan Hong

4.3

Get access to 101 Ready To Use Excel Macros that you can use straight away to your Excel workbooks & reports so you can SAVE HOURS each day!With this book you get the following cool features:- Access 101 Ready To Use Macros with VBA Code which your can Copy & Paste to your Workbook straight away & SAVE HOURS- Easy to Read Step by Step Guidewith Screenshots- Downloadable Practice Workbooks with VBA

42

Mastering VBA for Microsoft Office 2016

Richard Mansfield

4.3
Enhance productivity in any Office application with zero programming experienceMastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic t
43

Excel Macro Mastery - How You Can Write VBA Like a Professional in 15 Simple Steps

Paul Kelly

4.3
44

Statistical Analysis with Excel for Dummies

Joseph Schmuller

4.3
There's nothing random about it--this is the book on statistical analysis with Excel Stunned by statistics? Exhausted by Excel? Relax! Statistical Analysis with Excel For Dummies, 4th Edition shows you how to use the world's most popular spreadsheet program to crunch numbers and interpret statistics--even if you've never taken a statistics or advanced math course. In no time, you'll learn to use E
45

Mastering Excel Macros: Beginning to Code (Book 3)

Mark Moor

4.3
46

More Excel Outside the Box: Unbelievable Excel Techniques from Excel MVP Bob Umlas

Bob Umlas

4.3
A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software’s most challenging problems. Through a series of more than 30 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application and across all disciplines. Creative approaches for
47

Excel VBA & Excel Pivot Tables Crash Course: Ultimate Crash Course to Learn It Well and Become an Expert in VBA, Excel Macros & Pivot Tables. Smarter Way to Learn it faster and Remember it longer.

HEIN SMITH

4.3
48

Mastering Excel Macros: PowerPoint Automation (Book 7)

Mark Moor

4.3
VBA For Dummies book cover49

VBA For Dummies

John Paul Mueller

4.3
VBA helps you put your computer in its placeWrite programs that automate tasks and make Office 2007 work better for you

If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting
50

Mastering Excel Macros: Debugging (Book 2 of Mastering Excel Macros)

Mark Moor

4.3
51

Mastering Excel Macros: Introduction (Book 1)

Mark Moor

4.3
Access VBA Programming for Dummies book cover52

Access VBA Programming for Dummies

Alan Simpson

4.3
This friendly, easy-to-use guide shows experienced Access users how to use VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects Explains basic VBA skills and concepts for nonpr
Microsoft 365 Excel VBA Programming For Dummies book cover53

Microsoft 365 Excel VBA Programming For Dummies

Dick Kusleika

4.3

Your step-by-step guide to doing more with Microsoft ExcelFully updated for the latest version of Office 365, Excel VBA Programming For Dummies will take your Excel knowledge to the next level. With a little background in Visual Basic for Applications (VBA) programming, you can go well beyond basic spreadsheets and functions. Learn the coding basics and syntax you need to write simple or complex m

Programming Excel with VBA and .Net: Solve Real-World Problems with Excel book cover54

Programming Excel with VBA and .Net: Solve Real-World Problems with Excel

Jeff Webb

4.3
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and pre
55

Office VBA Macros You Can Use Today: Over 100 Amazing Ways to Automate Word, Excel, PowerPoint, Outlook, and Access

Juan Pablo González

4.2
For any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures provided. Tasks covered include how to run several mail merges at once, removing duplicates from
56

Programming Excel with VBA: A Practical Real-World Guide

Flavio Morgado

4.2
Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-
57

Holy Macro! It's 1,600 Excel VBA Examples

Hans Herber, Bill Jelen

4.2
58

Excel VBA in Easy Steps

Ed Robinson

4.2
Learning to program in Excel VBA is easy! The Visual Basic programming language is available and waiting in Excel itself - ready to be used. This book will help you utilize the full power of Excel to write and extend macros. It will also allow you to learn to program in Visual Basic - without the expense of buying the Visual Basic software! Its easy, step-by-step, colourful, illustrated approach i
Microsoft Excel Mastery: From Beginners to Experts – The Complete Guide to Formulas, Functions, and Real-World Applications (Business Productivity Blueprint) book cover59

Microsoft Excel Mastery: From Beginners to Experts – The Complete Guide to Formulas, Functions, and Real-World Applications (Business Productivity Blueprint)

Ethan Wells, Modern Work Publishing

4.2

Learn practical Excel skills for today’s workplace, from formulas, charts, and dashboards to AI-assisted tools like Copilot and ChatGPT If Excel feels like the one skill holding you back at work, you’re not alone.Coworkers finish reports in minutes. Job postings keep asking for Excel. And now AI tools like Copilot and ChatGPT are changing how people write formulas, clean data, create charts, and a

Excel VBA in easy steps book cover60

Excel VBA in easy steps

Mike McGrath

4.2
Excel VBA in easy steps begins by explaining how to record and edit macro procedures to manipulate Excel worksheet entries, then describes how to create your own macro programs in the Visual Basic Editor (VBE) that is included with the Excel application. This book then demonstrates how to program Excel procedures, provide Excel user forms, and create Excel apps. Each chapter builds your knowledge
61

Excel 2019 Power Programming with VBA

Michael Alexander and Dick Kusleika

4.2
Maximize your Excel experience with VBAExcel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800
62

Microsoft Access 2010 VBA Programming Inside Out

Andrew Couch

4.2
You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!


Enha
63

Microsoft Access 96: Developer's Handbook

Paul Litwin, Ken Getz, Mike Gilbert, Greg Reddick

4.2
Microsoft Access 2000/Visual Basic for Applications Fundamentals book cover64

Microsoft Access 2000/Visual Basic for Applications Fundamentals

Evan Callahan

4.2

MICROSOFT® ACCESS 2000 VISUAL BASIC® FOR APPLICATIONS FUNDAMENTALS is the teach-yourself guide to using Microsoft Visual Basic for Applications (VBA) to take control of Access. You’ll learn to automate databases, write your own functions and procedures, customize menus and toolbars, connect applications to the Web, and more. The easy-to-follow lessons include clear objectives and real-world busine

65

VBA and Macros for Microsoft Office Excel 2007

Bill Jelen, Tracy Syrstad

4.2
In this day and age of too much information and not enough time, the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of. Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques
Going Gas: From VBA to Google Apps Script book cover66

Going Gas: From VBA to Google Apps Script

Bruce Mcpherson

4.2
Whether you're moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.

Office still supports VBA, but it's not likely to do so for much longer. If you're a VBA or .NET developer, you'll learn how to port existing VBA code and structure to their
67

Microsoft Visual Basic 2015 for Windows Applications: Introductory

Corinne Hoisington

4.2
Now you can prepare for the number one job in the tech sector -- app development - as you learn the essentials of Microsoft Visual Basic with the step-by-step, visual approach and professional programming opportunities in MICROSOFT VISUAL BASIC 2015 FOR WINDOWS APPLICATIONS: INTRODUCTORY. This book lays the initial groundwork for a degree in IT programming as it equips you with a fundamental under
68

Mastering VBA for Microsoft Office 2010

Richard Mansfield

4.2
A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite fo
69

Excel 2007 VBA Programming for Dummies

John Walkenbach

4.2
Step-by-step instructions for creating VBA macrosHarness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create cu
70

Dan Appleman Visual Basic Programmer's Guide to the Win32 API (Book with CD-Rom)

Dan Appleman

4.1
71

Excel VBA Programming for Dummies

Michael Alexander and John Walkenbach

4.1
Take your Excel programming skills to the next level

To take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.

Inside, you'll find an overview of the essential elements
72

Visual Basic 2008 Programmer's Reference

Rod Stephens

4.1
Providing programmers and developers of all skill levels with a comprehensive tutorial and reference to Visual Basic (VB) 2008, Microsoft MVP Rod Stephens presents a broad, solid understanding of essential topics on the latest version of VB. He explains the forms, controls, and other objects that VB furnishes for building applications in a modern windows environment. Plus, he examines the powerful
73

Excel VBA 24-Hour Trainer

Tom Urtis

4.1
Master VBA automation quickly and easily to get more out of ExcelExcel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This s
74

VBA and Macros for Microsoft Excel

Bill Jelen

4.1
Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, u
75

Mastering Excel Macros: Arrays

Mike Girvi

4.1
76

Sekai De Ichiban Kantan Na Ekuseru Buibīē No Īhon: Ekuseru Buibīē No Kihon To Kangaekata Ga Wakaru Hon Saishinban

Daisuke Dōyō

4.1
Strategic Excel Mastery: Step-by-Step Projects, Templates, and Advanced Excel Skills, Including PivotTables and XLOOKUP, to Turn Messy Data into Clear Reports Without Overwhelm book cover77

Strategic Excel Mastery: Step-by-Step Projects, Templates, and Advanced Excel Skills, Including PivotTables and XLOOKUP, to Turn Messy Data into Clear Reports Without Overwhelm

Elliot Gridwell

4.1

Turn messy, stressful spreadsheets into clear, reliable reports your boss actually trusts.Do you spend way too much time fixing broken formulas and “mystery” spreadsheets instead of doing real analysis?Do you feel uncomfortable with XLOOKUP, PivotTables, and dashboards—even though you know they’re the key to your next promotion?Do you wish you had one practical, step-by-step Excel guide you could

78

Access 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Armen Stein

4.1
Access 2007 VBA Programmer's Reference covers a wide spectrum of programming topics relevant to Access. Although it assumes the reader has some familiarity with VBA programming language, it begins with a brief introduction to VBA. And to help you leverage the tools that Access provides, a chapter highlights the new features in Microsoft Office Access 2007 -- including new wizards and GUI (graphica
79

Financial Analysis and Modeling Using Excel and VBA

Chandan Sengupta

4.1
VBA For Beginners Not Dummies book cover80

VBA For Beginners Not Dummies

Gerry McSweeney

4.1

This book will teach you how to create your own VBA programs.If you're a non-programmer it'll also teach you the fundamentals of coding.If you're already a programmer and want to apply your skills in VBA then this is your starting point.Even if you already know VBA you'll probably find some useful tit-bits.The book is split into 3 main sectionsIntroductionBasic BASICVBA EssentialsThe “Introduction

81

PowerPoint for Teachers: Dynamic Presentations and Interactive Classroom Projects (Grades K-12)

Ellen Finkelstein, Pavel Samsonov

4.1
PowerPoint for Teachers is written for especially for teachers like you, who want to use PowerPoint in the classroom to enhance your presentations, teach your students how to use the application, and create interactive educational projects. No matter what your level of expertise--just getting started or seasoned pro--PowerPoint for Teachers gives you the step-by-step information you need to introd
82

Learn VBA Fast, Vol. II: Excel function design course, with practice exercises (The VBA Function Design Course Book 2)

D Armstrong

4.1
83

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye

4.1
You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fas
84

Excel VBA: Tips and Tricks to Learn and Understand Excel VBA for Business Analysis

Daniel Jones

4.1
Writing Word Macros book cover85

Writing Word Macros

Steven Roman Phd

4.1
Many Microsoft Word users and VBA programmers don't realize the extensive opportunities that exist when Word's Object Model is accessed using Visual Basic for Applications (VBA), which replaced WordBasic in conjunction with the release of Word 97. By creating what is commonly called a "Word Macro" you can automate many features available in Word. Writing Word Macros (previously titled Learning Wor
86

Mastering VBA for Microsoft Office 2007

Richard Mansfield

4.1
Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syn
87

Learn Access 2003 VBA with the Smart Method

Mike Smart

4.0
Who is this book for?

If you've never written VBA code before this book will show you how.

This book is for Access developers who:




Are comfortable with all aspects of the interactive use of Access
Are already able to design simple relational databases
Want to learn VBA skills from first principles
Want to learn how to develop professional-grade Access applications
What you will learn

This unique book prov
44 The Most Popular Macros for Access 2023 and Access 365: Advanced techniques for automating Access using macros and VBA (VBA & macros book cover88

44 The Most Popular Macros for Access 2023 and Access 365: Advanced techniques for automating Access using macros and VBA (VBA & macros

Klemens Nguyen

4.0

Are you ready to take your Microsoft Access skills to the next level? "44 The Most Popular Macros for Access 2023 and Access 365" is your comprehensive guide to mastering the power of macros and VBA in Access. Whether you're a beginner looking to automate routine tasks or an experienced user seeking advanced techniques, this book is your roadmap to efficiency and productivity. Dive into a treasure

89

Excel VBA Bundle (2 Books): Excel VBA and Macros and 51 Awesome Macros

Philippe A. Louis

4.0
90

Microsoft Visual Basic 2015 for Windows, Web, Windows Store, and Database Applications: Comprehensive

Corinne Hoisington

4.0
Now you can prepare for the number one job in the tech sector -- app development - as you master Microsoft Visual Basic with the step-by-step, visual approach and professional programming opportunities in MICROSOFT VISUAL BASIC 2015 FOR WINDOWS, WEB, WINDOWS STORE, AND DATABASE APPLICATIONS: COMPREHENSIVE. This book lays the groundwork for a degree in IT programming as it equips you with a solid u
91

The Little VBA Book

Robin Grieves, Myoung Cheol Seo, et al.

4.0
If you have ‘Excel’ on your resume but cannot write VBA macros, then you are at a serious disadvantage in today’s labor market. All of your competitors also know 'Excel' and many of them use sophisticated functions. Whether you are seeking a new job, trying to make yourself indispensible or just up-skilling, we take Excel users from dead-zero in VBA programming to functional VBA skills in one day!
92

Excel 2016 Power Programming with VBA

WILEY INDIA

4.0
93

Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need

Hans Herber, Bill Jelen, Tom Urtis

4.0
This guide to unleashing the power of Microsoft Excel by using Excel's VBA programming language shows nonprogrammers how to solve real-life problems with Excel VBA. Thousands of concise code samples are accompanied by sample workbooks in a question-and-answer format that describes each specific task.
94

Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook: VSTO for Excel, Word, Outlook, and InfoPath (Microsoft .Net Development)

Eric Carter, Eric Lippert

4.0
"Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook "is the definitive book on VSTO 2008 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Microsoft Visual Studio 2008 and the .NET Framework to program against Microsoft Office 2007. This book delivers in one place all the information you
95

Mastering VBA for Microsoft Office 2013

Richard Mansfield

4.0
A unique, comprehensive guide to creating custom apps with VBA

Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable
LEARN VISUAL BASIC (VBA) AND MACROS FOR MICROSOFT EXCEL: + 100 exercises, macros, and games solved to enhance your programming skills book cover96

LEARN VISUAL BASIC (VBA) AND MACROS FOR MICROSOFT EXCEL: + 100 exercises, macros, and games solved to enhance your programming skills

Mr. JOSEP RAMON VIDAL, Edt. Magic Unicorn

4.0

Excel VBA in easy steps. Excel VBA Programming For Everyone!This practical book is recommended at developers and Excel users who want to learn how to work with VBA effectively and enjoyably. It covers basic programming concepts as well as advanced techniques.Visual Basic for Excel is a powerful tool that enables you to automate tasks, create custom macros, and enhance spreadsheet capabilities.This

97

VBA Programming for Microsoft Project '98 Through 2010 with an Introduction to VSTO

Rod Gill and Jack Dahlgren

4.0
This book teaches you to develop VBA macros for Microsoft Project that are productive, quick to develop, and easy to maintain. The learning examples included in this book give you a great jumpstart for your own Project VBA programming projects. I document an array of useful macros, including routines for viewing all tasks linked to the selected one, automatically creating a consolidated snapshot o
98

Excel Macros for Dummies

Michael Alexander

4.0
Ready-made Excel macros that will streamline your workflowExcel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find the most effective Excel macros for
99

VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel

S. Christian Albright

4.0
Help your students master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office, with this essential tool. Chris Albright's VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E provides everything you need to teach students how to automate common spreadsheet tasks as well as create the sophisticated man
100

Learn VBA Fast, Vol. III: Excel function design course, with practice exercises (The VBA Function Design Course Book 3)

D Armstrong

4.0