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
