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

VBA Codings

ResolvedVersion 2003

Thu 14 Aug 2008, 17:00 Delegate Adil said...

Adil has attended:
Excel VBA Intro Intermediate course

VBA Codings

where do i get the codes from

Thu 4 Sep 2008, 10:39 Edited on Thu 4 Sep 2008, 10:40 Trainer Carlos said...

RE: VBA Codings

Hi Adil

Sorry for the delay in answering this question.

There are many places you can look up how VBA code is written.

The easiest one is Microsofts own Help section.

1. Open Excel

2. Select the Help menu and click Microsoft Excel Help or press F1

3. In the Excel Help task bar click Table of contents

4. in the list click Microsoft Excel Visual Basic Reference

Here you will find folders with examples of how each factor of Excel VBA works and examples of how to code them.

Hope this helps

Regards

Carlos

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:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

VBA Codings

VBA Codings

RE: VBA Codings

Excel articles

Excel tip:

Sum Up All the Values in A Column