DOCUMENT:Q180487 15-NOV-2001 [vbwin] TITLE :DOC: For Each ... Next Statement Does Not Work for Collections PRODUCT :Microsoft Visual Basic for Windows PROD/VER::3.0 OPER/SYS: KEYWORDS:kbToolkit kbVBp kbVBp500 kbVBp600 kbOSWinCEsearch kbOSWinCE100 kbGrpDSVB ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft eMbedded Visual Basic, version 3.0 - Microsoft Windows CE Toolkit for Visual Basic 6.0 ------------------------------------------------------------------------------- SUMMARY ======= In the Help topics for eMbedded Visual Basic (eVB) and Microsoft Windows CE Toolkit for Visual Basic (VBCE), the description for the "For Each ... Next" statement is as follows: "Repeats a group of statements for each element in an array or collection." However, this is not true for collections because you cannot declare a collection in either eVB or VBCE. MORE INFORMATION ================ Unlike the information presented in the Help documentation, the following code will not work in either eVB or VBCE because the New keyword is not supported: Private Sub Command1_Click() Dim col As New Collection Dim vnt col.Add "Item1" col.Add "Item2" col.Add "Item3" col.Add "Item4" For Each vnt In col MsgBox vnt Next End Sub Additional query words: wince vbce vbce6 evb ====================================================================== Keywords : kbToolkit kbVBp kbVBp500 kbVBp600 kbOSWinCEsearch kbOSWinCE100 kbGrpDSVB Technology : kbVBSearch kbAudDeveloper kbZNotKeyword2 kbVBeMbSearch kbWinCETKVBSearch kbWinCESearch kbVBeMb300 Version : :3.0 Solution Type : kbpending ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.