VBA

Resolved · Low Priority · Version 2003

Mon 14 Dec 2009, 16:31 Delegate Andrew said...

Andrew has attended:
Excel VBA Intro Intermediate course

VBA

Do you have a recommended best practice for an overall structure / approach to coding in VBA. (E.g. The key steps to take when approaching a coding project)

Thu 17 Dec 2009, 11:48 Trainer Stephen said...

RE: VBA

Hi Andrew

Thanks for your question

This is a massive subject in its own right. Whole books have been written on the subject.

I would suggest the following as a general approach

1. Id the outputs that you require. What data do you need to show
2. Id the inputs, what data will youi start with.
3. List the steps and analysis required to turn your inputs into outputs
4 Break the steps in three above, into a set of discreet operastions and then write the code
5. Finish by building interfaces for your users and formatting tghe data output

Regards

Stephen

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:

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)