98.7% 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 » vba courses london - List of variables
vba courses london - List of variables
Resolved · Low Priority · Version Standard
Fri 23 Feb 2007, 15:59Delegate Marie said...
Marie has attended:
Excel VBA Intro Intermediate course
List of variables
is there any easy way of pulling out a list of all your public/private variables you've entered in your code? (so you can see what you've done without having to go into the code)
Thu 1 Mar 2007, 17:08Trainer David said...
Excel VBA varibles
Hi Marie
As far as know there is no way to do exactly what you asked. However you can write a piece of code after each of the variables and get it to print out a useful message, ie variable name and purpose. You could get it to print out to a a form or word doc or text file or to excel itself.
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:Empty The Clipboard with CutCopyModeAfter each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload: |
