While End While doesn t work in VBA

Question

The code below is VBA for Excel  I am using the Visual Basic editor that comes with Excel 2007     Dim counter As Integer counter   1 While counter  lt  20     counter   counter   1 end while   lt - the compiler is complaining about this statement   The code doesn t compile  Above the code I have only declarations  According to MSDN   this should work but it doesn t  What has happened

User · Answer

VBA is not VB VB NET  The correct reference to use is Do  Loop Statement  VBA   Also see the article Excel VBA For  Do While  and Do Until  One way to write this is   Do While counter  lt  20     counter   counter   1 Loop    But a For  Next might be more appropriate here    Happy coding

User · Answer

While constructs are terminated not with an End While but with a Wend    While counter  lt  20     counter   counter   1 Wend   Note that this information is readily available in the documentation  just press F1  The page you link to deals with Visual Basic  NET  not VBA  While  no pun intended  there is some degree of overlap in syntax between VBA and VB NET  one can t just assume that the documentation for the one can be applied directly to the other    Also in the VBA help file      Tip   The Do   Loop statement provides a more structured and flexible way to perform looping

[vba] "While .. End While" doesn't work in VBA?

Examples related to vba

Examples related to excel