Optional parameter in function

[amit25007]

Hello

I am unable to put optional parameter in function.
below is an example

Code:

Public Function fun(var1, var2, var3, var4) Script End Function

I don't want to enter value to var4 every time I use function. I want var4 to be optional.


Regards
Amit

[abhideshpande001]

I think this is not possible. I would suggest Make two functions with 3 and 4 parameters and write it like this in script.

Code:

If Condition Call Fn1(Var1, Var2, Var3) Else Call Fn2(Var1,Var2,Var3,Var4)

[amit25007]

But with this method, i still don't have choice with Var4. The case is i will enter value of Var4 only in some specific cases, not always.

[cuongtv]

Another way, using Null or Empty argument:

Code:

Function myfunc(arg1,arg2,arg3,arg4) If IsNull(arg1) OR IsEmpty(arg1) 'ignore arg1 Else 'use arg1 End If If IsNull(arg2) OR IsEmpty(arg2) 'ignore arg1 Else 'use arg1 End If ..... 'Your code is here End Function

To call your function:

Code:

Dim a a = myfunc(NULL,arg2,,arg4)

[abhideshpande001]

You can also use dynamic parameters using dictionary object/array.

[vinod123]

Use switch case method to call the different variables in different cases

[venkatesh9032]

If u dont want to pass the value in the argument u can leave empty instead of removing parameter.

Please find the snippet:

Code:

Fun Abc(Par1,Par2,Par3,Par4) --- -- End Function Call Abc("1","",2","3")