Multiple of a Variable in an If function?

[ironhydroxide]

I am looking to use an IF function and i want the code to do a certain
something if the variable used is a multiple of 6. (i know this is fixable
with fairly simple math, but i havent even thought about algebra for 4years)

i want the code to look something like this
If Variable1 Is (Multiple of 6) then
Code....
Code...
End If

Thanks

ironhydroxid

 

[Jacob Skaria]

If variable mod 6 = 0 then
'your code
End If

If this post helps click Yes

 

[ironhydroxide]

You are amazing!!

If variable mod 6 = 0 then
'your code
End If

If this post helps click Yes

 

[AltaEgo]

Function MultOfSix(x) As Boolean

MultOfSix = x / 6 = Int(x / 6)

End Function


To use:

If MultOfSix(yourVar) then
'your code
Else
'not multiple of six
End If