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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

VBA Procedures

ResolvedVersion 2007

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

Manjot has attended:
Excel VBA Intro Intermediate course

VBA Procedures

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

Fri 17 Dec 2010, 12:35 Trainer 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 tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

VBA Procedures

VBA Procedures

RE: VBA Procedures

Excel articles

Excel tip:

Change the Value of a Constant