Printing

Resolved · Low Priority · Version 2003

Tue 15 Sep 2009, 16:30 Delegate Katya said...

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?

Thu 17 Sep 2009, 10:12 Trainer Stephen said...

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

Fri 18 Sep 2009, 10:17 Delegate Katya said...

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

Thu 24 Sep 2009, 11:31 Trainer Stephen said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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