The UK's Number 1 for Microsoft Office Training

Sitemap

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 training london - VBA

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

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

vba training london - VBA

Resolved · Low Priority · Version Standard

ReplyThu 12 Jul 2007, 10:02Delegate Clare said...

VBA

What is a loop?

For upcoming training course dates see: Pricing & availability

ReplyThu 12 Jul 2007, 16:05Trainer David said...

RE: VBA

Hi Clare

A loop is basically just a set of statements that run until a condition is set.

For example:

i=0

if i <= 10

do something
i++

The above is pseudocode for a loop, this loop will do something until i reaches 10.

Hope this helps
David

VBA articles

· VBA - Not Just For Programmers
· Why Use VBA In The Office 2010 Suite?
· VBA For Beginners - Only A Script Away From Endless Possibilities...
· Tips On Getting VBA Bugs To Bug-off
· VBA With Excel - Making The Working Day That Little Bit Easier

Vba tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips

No need to respond

» Forum post: Test

Rate this page:

Currently 2.16/5
1
2
3
4
5

2.2/5 (211 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions