access vba course - Variable

The UK's most regular instructor-led training courses.
Training information: access vba course · Excel london

Resolved · Low Priority · Version Standard

Variable

Debbie has attended:
Excel VBA course
Excel VBA course

by - delegate Debbie [3 posts] (2007 Jul 4 Wed, 16:38) Reply

How do you make a variable that can be seen by all projects?

RE: Variable

by - trainer David gold contributer [428 posts] (2007 Jul 4 Wed, 17:20) Reply

Hi Debbie

From you question I believe the answer is to declare the variable global.

If however when you say projects, you mean a completely separate piece of code that is run by a different files and is no way linked to the other project I don't think there is a way to make the variable seen by both projects.

Hope this helps

David

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips