#1   Report Post  
Posted to microsoft.public.excel.misc
Sally
 
Posts: n/a
Default vba question

What does the function "Do While......" do in VB coding
--
Thanks
Sally
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summary Page Question EyeNoNothing via OfficeKB.com Excel Discussion (Misc queries) 1 February 18th 06 10:03 PM
Pivot table question gary Excel Discussion (Misc queries) 1 January 10th 06 06:25 PM
Follow-Up (Clarification) to MIN question Odawg Excel Discussion (Misc queries) 4 October 20th 05 04:04 AM
Benefits many people - Question ebgehringer Excel Discussion (Misc queries) 0 October 7th 05 09:22 PM
How do I find and replace a question mark in Excel? Ranpalandil Excel Discussion (Misc queries) 1 September 7th 05 10:20 PM


All times are GMT +1. The time now is 03:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"