Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA Procedures

Resolved · Low Priority · Version 2007

Reply Thu 16 Dec 2010, 15:47Delegate Manjot said...

Manjot has attended:
Excel VBA Intro Intermediate course

VBA Procedures

What is the difference between a sub procedure and a function procedure?

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Dec 2010, 12:35Trainer Stephen said...

RE: VBA Procedures

Hi Manjot

Thanks for your question

In general there are two types of procedure. A function procedure carries out a series of calculations and returns a specific value. Sub Procedures are more general and while they can carry out calculations, they do not return a value

Regards

Stephen

Thu 23 Dec 2010: Automatically marked as resolved.

Excel articles

· Getting To Grips With Gantt In Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Discover How To Use Fill In Excel
· Create A Basic Timeline In Excel
· Tips From Excel's 'Rarely Used' File

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

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips