VBA

The UK's most regular instructor-led training courses.
Training information: excel vba course london · Excel/courses/london · VBA courses London UK

Resolved · Low Priority · Version 2000

VBA

Terry has attended:
Excel VBA course

by - delegate Terry [1 post] (2008 May 8 Thu, 16:38) Reply

Is there a function similar to Exit Sub that comes out of the whole runtime rather than just the current sub?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: VBA

by - trainer Carlos gold contributer [394 posts] (2008 Jun 3 Tue, 13:40) Reply

Hi Terry

The short answer is No

Although you can exit a Sub there is no direct way of exiting the whole Module.

Regards

Carlos

· A Beginners Guide To Formulas In Excel
· Customized Financial Excel Courses in London
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· How Excel Training Can Improve Your Company's Sales Process
· Identifying Suitable Candidates For VBA For Excel Training

Please browse our web site to find out more about
excel vba course london and other Microsoft training courses.

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips