VBA in a Nutshell Just to let you know what you’re in for, I’ve prepared a quick and dirty summary of what VBA is all about. Of course, I describe all this stuff in semiexcruciating detail later in the book. ✓ You perform actions in VBA by writing (or recording) code in a VBA module. You view and edit VBA modules by using the Visual Basic Editor (VBE). ✓ A VBA module consists of Sub procedures. A Sub procedure has nothing to do with underwater vessels or tasty sandwiches. Rather, it’s a chunk of computer code that performs some action on or with objects (discussed in a moment). The following example shows a simple Sub procedure called AddEmUp. This amazing program displays the result of 1 plus 1. Sub AddEmUp() Sum = 1 + 1 MsgBox “The answer is “ & Sum End Sub A Sub procedure that doesn’t perform properly is said to be substandard.
Posted on: Tue, 03 Sep 2013 11:23:52 +0000
Trending Topics
Recently Viewed Topics
© 2015