IF UserForm TextBox Value = multiples

[Big Lar]

If TextBox10.Value = -4 Then...

Can this be modified to work on multiples of -4?

 

[Big Lar]

Let's try this again...

If TextBox10.Value = -4 Then
Do something
End If

Is there a way to code the If to "Do Something" when TextBox10.Value = -4, or any multiple of -4?

 

[Norie]

You could try this

If Abs(TextBox1.Value) Mod 4 = 0 Then
    MsgBox "The value entered is a multipe of -4."
End If

Mind you I don't think that's exactly what you want.

It will include all multiples of -4 including positive numbers.

 

[Big Lar]

Thanks Norie. That works fine.