[RESOLVED] How to check counter for particular numbers

[jmsrickland]

When the counter is 4, 7, 10, 13, 16, 19, 22, etc, etc, etc for as many counts as needed I need to do something slightly different on those particular count values. How do I check for those values without using a bunch of If statements or a Select Case?

[si_the_geek]

Determine the pattern, and create a check based on it.

In this case they seem to be multiples of 3, plus one... so check for that.

If (x - 1) Mod 3 = 0 Then
  '4 etc
Else
  'Other numbers
End If

[jmsrickland]

That works and I tried it however it also includes 0 which I can overcome by just checking if number is > 1 but I was just thinking if there is a way without the additional If x > 1 Then

x=1
If (x - 1) Mod 3 = 0 Then

[si_the_geek]

Adding >1 is the easiest way.

[jmsrickland]

Thanks, si. I'll use your code.