VbA

Resolved · Low Priority · Version 2003

Wed 20 Oct 2010, 17:24 Delegate Steph said...

Steph has attended:
Excel VBA Intro Intermediate course

VbA

How do I get the program to loop through all of the sales people or manufactuers?

Mon 25 Oct 2010, 09:35 Trainer Stephen said...

RE: VbA

Hi Steph

Thanks for your question

I am assuming you are referring to the exercise on the course.

This is fairly simple to achieve. All salespeople and manufacturers are described on the list page. Simply create a procedure that loops through each name. (you could adapt the code that populates the combo boxes for this). At each step, set the variable strName or strMan equal to the salesperson or manufacturer in question, and then call the main sales or main manufacture procedure. This will then run the report for each individual

Hope this helps

Regards

Stephen

Sun 31 Oct 2010: Automatically marked as resolved.

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:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips