98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Printing
Printing
Resolved · Low Priority · Version 2003
Katya has attended:
Excel VBA Intro Intermediate course
Printing
This is a really basic question (!) which I never thought to ask on the course - can you print in VBA?
RE: Printing
Hi Katya
Thank you for your question
Can you clarify your question for me?
Specifically do you want to be able to print out your code, or print a worksheet using VBA commands?
Thanks
Stephen
RE: Printing
Sorry, I wanted to print out my codes in VBA. I just find it easier when setting up new sheets to use ones already set up rather than flicking from screen to screen - just the way I work. Then I can copy and paste or re type following my print.
Does that make sense?
Many thanks
Katya
RE: Printing
Hi Katya
Thanks for the clarification
There is a print command in the VBE.
Click on the File menu item and select print. You then have the option to print the current module or the entire project.
If you have a form object selected, you can also choose to print either the code or an image of the form
Regards
Stephen
Thu 1 Oct 2009: Automatically marked as resolved.
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. |
Excel tip:Sorting data stored in rowsPrimarily Excel is set up to sort data that is stored in columns rather than rows. |