How do you pass arguments to VBA functions other than ByVal and ByRef?
Here the recruiter is looking for additional VBA knowledge that MIS executives must possess. To answer this MIS job interview question, you can mention that there are a few other ways to pass arguments.
Optional arguments : The Optional keyword specifies arguments as Optional. An Optional argument should be declared as a Variant data type. This enables the use of IsMissing function.
Parameter Arrays : Other than the three fixed arguments mentioned above, one can also pass a number of random arguments. This is done by using the ParamArray keyword.
