98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » access vba course - Variable
access vba course - Variable
Resolved · Low Priority · Version Standard
Wed 4 Jul 2007, 16:38Delegate Debbie said...
Debbie has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Excel Pivot Tables course
Variable
How do you make a variable that can be seen by all projects?
Wed 4 Jul 2007, 17:20Trainer David said...
RE: Variable
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Suspend DisplayAlerts in VBATo 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: |
