Select Case on Iterator Variable Not Working As Expected

[ExcelChemist]

I have had this problem in multiple different macros so I will just provide an example of relevant code:

For J = 0 To 3

    Select Case J
    Case J = 0
    LikeVar = "a*spk1*E0"
    LikeVar2 = "a*spk1*E7"
    
    End Select
Next J

For some reason it skips over the likevar variable assignments even though J = 0 on the first time through the loop. I have tried changing the For line to J = 1 to 3, and the case to J = 1, but it still skips to the end select. Is it not possible to use a select case on an iterator variable? Thanks in advance for any input.

 

[BiocideJ]

It should read

Select Case J
Case 0
...

instead of

Select Case J
Case J = 0
...

You already delcared the case to examine as J in the line above.

 

[RoryA]

For J = 0 To 3

    Select Case J
    Case 0
    LikeVar = "a*spk1*E0"
    LikeVar2 = "a*spk1*E7"
    
    End Select
Next J

otherwise you are comparing J to (J = 0) which is comparing 0 to True.

 

[ExcelChemist]

Thanks a lot, I figured it was something simple and stupid

 

[Firefly2012]

THis line:

Case J = 0

is actually the same as

Case True

when j=0, thus you don't get a match.

You therefore simply need:

Case 0