Independently Published, 2019. — 310 p. — ISBN 1081431210.
You need to understand and implement the power of Visual Basic for Applications (VBA). You'll find an overview of the essential elements and concepts for programming with Excel. You'll discover techniques for handling errors and exterminating bugs, working with range objects and controlling program flow, and etc.
Create a Macro
MsgBox
Workbook and Worksheet Object
Range Object
Variables
If Then Statement
Loop
Macro Errors
String Manipulation
Date and Time
Events
Array
Function and Sub
Application Object
ActiveX Controls
Userform