AnsweredAssumed Answered

different from series of numbers

Question asked by Lasse Nielsen on Mar 9, 2017
Latest reply on Mar 9, 2017 by Deepak Gupta

Hello forum,

 

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?

Outcomes