Declarations

Resolved · Medium Priority · Version 2003

Tue 29 Apr 2008, 12:24 Delegate 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:13 Trainer 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