Tue 29 Apr 2008, 12:24Delegate Joshua said...
Joshua has attended:
Excel VBA Intro Intermediate course
Declarations
How do declarations work in the VBA scripting and when should they/could they be used?
Fri 1 Aug 2008, 15:13Trainer Carlos said...
RE: Declarations
Hi Joshua
Declaration statements are used to declare variables.
A variable declaration establishes its name, scope and data type. eg:
Dim UserName as String
They should be used to declare every variable you need in the code.
Furthermore you should always ensure that the Option Explicit statement is in the Declarations area of your code.
Hope this helps
Carlos
