Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - For loop

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba courses london - For loop

Resolved · Low Priority · Version Standard

Reply Thu 8 Mar 2007, 09:40Delegate John said...

John has attended:
Excel VBA Intro Intermediate course

For loop

How do you do a 'for' loop?

For upcoming training course dates see: Pricing & availability

Reply Fri 9 Mar 2007, 16:12 Edited on Fri 9 Mar 2007, 16:18Trainer Carlos said...

RE: for loop

John

An simple example of the for loop is:

For Counter = 1 to 100

Total = total + Cells(NoRows,4).value

Next Counter

VBA articles

· Driving MS Products Forward With The Help Of VBA
· Tips On Getting VBA Bugs To Bug-off
· OOPS Visual Basic Did It Again
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Create An Excel VBA Add In

Vba tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips