Is it possible for a macro to determine if a user input value is different from a series of numbers?
Lets say the user can input any value he imagines, but the macro should only run if the number is equal to
20, 25, 32, 40, 50, 63, 75, 90, 110 and a bunch more. Total of 30 numbers
Something like this?
If PPD.Text <> (number series) Then MsgBox "Error", vbOKOnly, "Value error"
Or how do i go about this in the shortest amount of code?