Books

I believe learning should start with small steps, otherwise one might get discouraged. For that reason, I have put together a simple guide to get you started with a solid foundation in no time. The Excel VBA Guide for Beginners is just 75 pages long with lots of VBA code examples and illustrations, so it should not take you more than a few days or weeks to read it and understand it. It consists of ten comprehensive chapters covering each of the key areas of Excel VBA, and an appendix section with the description of commonly used Excel VBA objects and the full list of VBA functions. 

If you already have a basic knowledge of Excel VBA, or if you have read the guide for beginners above, this is the way to go to get your Excel VBA skills to the next level. The introductory chapter expands on the Excel Object Model and helps understand all about working with objects. The following chapters focus on each of the 10 most important Excel VBA objects. It is a 142 pages to read with an extensive appendix as part of it, including the full list of Excel VBA objects, the properties, methods, and events, for the objects covered in the guide, and the shape and chart types enumerations.  

This book explains how to create and program userforms in Microsoft Excel. The book is aimed at Microsoft Office users, with some basic knowledge of Visual Basic for Applications (VBA), who want to get the most out of userforms. The book covers from basic concepts  to more advanced userform programming techniques. It reviews all the properties, methods, and events of the UserForm object and each of the form control types. It also explains how to program userforms, add event handlers to multiple controls, add control programmatically, and much more. The book comes along a very helpful appendix with the list and description of properties, methods, and events of the UserForm and its controls. 

This book explains how to leverage and automate Outlook functionality from Excel with Visual Basic for Applications (VBA). It contains numerous macro examples to send email from Excel, extract emails, download attachments, reply to or forward emails automatically, create mail rules, manage the calendar and send meeting invites, re-schedule multiple meetings, find calendar availability, extract meeting attendees, save contacts, assign tasks, and much more. See the full list of macros below. The book introduces the Outlook object model and covers specifically each of the top-level Outlook objects in the hierarchy. 

This book reviews and explains different methods to generate and solve Sudoku puzzles with Excel VBA. The book is directed to Sudoku enthusiasts who have some knowledge of Microsoft Excel and basic VBA coding experience. It contains numerous macro examples to generate and solve Sudoku, rate the difficulty, and create UI components to play Sudoku in Excel. A workbook annex contains all the macros explained in the book and a few more.