printing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Printing

Printing

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips


Server loaded in 0.08 secs.