Muokkaa

Jaa


Statements or labels invalid between Select Case and first Case

You can place nothing but a comment between the Select Case statement and the first Case clause. This error has the following cause and solution:

  • You placed a statement between Select Case and its first Case clause. For example:

        Select Case SomeVar 
      ' This is a comment and is valid. 
      Stop ' Even a Stop statement is invalid here. 
      Case SomeValue 
      . . . 
      End Select 
    

    The Select Case statement must be immediately followed by its first Case statement. If the intervening expression is a comment, precede it with a comment delimiter ('). Otherwise, place the expression where it belongs or delete it.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.