Question

Explain WHILE...WEND loop with an the help of an example​

Answer 1

Explanation:

In a While…Wend loop, if the condition is True, all the statements are executed until the Wend keyword is encountered.

If the condition is false, the loop is exited and the control jumps to the very next statement after the Wend keyword.

Syntax

Following is the syntax of a While..Wend loop in VBA.

While condition(s)

[statements 1]

[statements 2]

...

[statements n]

Wend