vba question
 

What does the function "Do While......" do in VB coding
--
Thanks
Sally

vba question
 

See:

http://web.archive.org/web/200312061...101/vbc5-4.asp

It covers all the control structures in VBA. The parent document:

http://web.archive.org/web/200312040...01/default.asp

is a good source for other VBA topics.

http://msdn.microsoft.com/library/de...mmersguide.asp

is also good and oriented to professional apps.

--
Gary''s Student


"Sally" wrote:

What does the function "Do While......" do in VB coding
--
Thanks
Sally

vba question
 

Sally,

Do While is a looping structure. It causes code to be repeated
until some condition is False. For example

Dim Test As Boolean
Do While test = True
'
' your code here
'
test = False
Loop

This will execute the code in "your code here" repeatedly until
the variable Test is set to False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sally" wrote in message
...
What does the function "Do While......" do in VB coding
--
Thanks
Sally