Click to See Complete Forum and Search --> : Unknown # of parameters


October 19th, 1999, 12:00 PM
How to write a procedure that will have an unknown number of parameters and will display the each parameter value passed and its data type?

Is this possible?

Any help for this beginner very much appreciated.

czimmerman
October 19th, 1999, 01:49 PM
For the unknown # parameters problem, use a paramarray.

To display the datatype, use the VarType function.

See the documentation for more details.

Charlie Zimmerman
http://www.freevbcode.com