I want to use a parameter in a restricted way so that it only accept some defined input values.
For Example> I have created a parameter of type number but i want it to accept only 0,1 or 2 values. If you give any other value then t should give an error. Can anyone throw some light on this.
You Can Restrict Values to Parameters in Two
1) Declare Paramaeter as a Const
2) Define a Variable as a Array of Restricted Lenght
But how can you create an "Action parameter" of type constant.
One thing which came to my mind is we can select the datatype as number but how can we restrict the paramter to except values other than say 0,1 or 2.
when you access the parameter in your action, you could always do something along the lines of:
Select Case Parameter_Name
Case 0, 1, 2
msgbox "Error Values"
msgbox "Good Values"
I'm not a complete idiot - some parts are missing.