Use of "Continue" keyword giving compile time error

[Tejas Kore]

Hi Friends,

I am bit confused as this keyword("continue") exits or not in VBA. Then after googling I found this link
https://docs.microsoft.com/en-us/dotnet/visual-basic/language.../continue-statement

Here they have mentioned the use of this keyword. But when I tried to implement that it is giving error.

Here in the below code I have used [MsgBox ("Skipping")].Here I actually want to skip the iteration.
How can I achieve this ?

Sub test()


names1 = Array("Fox", "Elephant", "Rat")
For Each strsearch In names1
If strsearch Like "*an*" Then
MsgBox ("Skipping") 'Want to go to next iteration
Else
MsgBox (strsearch)
End If
Next strsearch
End Sub

 

[dmt32]

Hi,
Continue Keyword I personally, have never known to exist in VBA but perhaps another here may know differently.

You can use the Not Operator which may give result you are looking for

Sub test()
    
    names1 = Array("Fox", "Elephant", "Rat")
    For Each strsearch In names1
        If Not strsearch Like "*an*" Then
            MsgBox ("Skipping") 'Want to go to next iteration
        Else
            MsgBox (strsearch)
        End If
    Next strsearch
        
End Sub

Dave

 

[RoryA]

Continue is not valid in VBA. You can simply not put anything in the If block, or use Not as Dave suggested.

 

[Tejas Kore]

Thanks a LOT Rory And Dave !!!.
I chose the other option of writing nothing for implement this functionality in my code. Actually the link which I took reference of , which I have pasted above ,I got confused because of that .
And Thanks again for telling how to use 'Not'. I was using 'Like Not' which was giving compile time error again and again .