Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VBA For Statement

Posted on 2007-11-13
2
Medium Priority
?
10,927 Views
Last Modified: 2013-11-28
In the For VBA Statement below, you can count 1 to 10.
For I = 1 To 10
Next I

I wish to count from 10 to 9 using the for statement, is this possible.
0
Comment
Question by:doyle007
2 Comments
 
LVL 14

Accepted Solution

by:
ragoran earned 1600 total points
ID: 20277606
You can use the step instruction to specify the increment:

for i = 10 to 1 step -1

next i
0
 

Author Comment

by:doyle007
ID: 20277758
Thanks Ragoran, that worked a treat
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question