Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 training course - VBA

excel 2003 training course - VBA

ResolvedVersion Standard

Fri 1 Feb 2008, 16:41 Delegate Ashpal said...

Ashpal has attended:
Excel Intermediate course
Excel Advanced course

VBA

Is it possible to manipulate macros recorded in Excel in VBA?

Sun 10 Feb 2008, 11:53 Trainer Stephen said...

RE: VBA

Hi Ashpal,

Thankyou for your question.

It is indeed possible.

If you press ALT-F11 you will open the VBE, which is the environment in which you can write code

Your macro will be stored in a module, and once located you can then modify any aspect of it that you require.

Note however if you are going to make major changes then it is often better to write the thing from scratch than recording it.

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips

excel 2003 training course - VBA

VBA

RE: VBA

Excel articles

Excel tip:

Creating a range of monthly payments as text