access vba books - excel vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft VBA Training and help » access vba books - Excel Vba

access vba books - Excel Vba

resolvedResolved · Low Priority · Version Standard

Shaun has attended:
Excel VBA Intro Intermediate course

Excel Vba

How do you get a Loop to work?

RE: Excel Vba

Shaun

In VBA a loop is a block of code executed repeatedly as long as a certain condition exists.

A loop must have a start command that sets the condition, the block of code and the end command eg:

Do Until X = 100

[Block Of Code]

Loop

OR

For Counter = 1 To 100

[Block Of Code]

Next Counter

Regards

Carlos

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

VBA tip:

Display Text In a Msgbox On Multiple Lines

When displaying text in a MsgBox you may need to show it over multiple lines. To do this use:

vbCrLf

As in:

MsgBox "The System has detected an error." & vbCrLf & "Contact your System Administrator"

The first sentence in quotes will appear above the second in the MsgBox.

View all VBA hints and tips


Server loaded in 0.07 secs.