running a function with multiple variables left blank

Trying to figure out how to run a function that takes 3 variables, but would like the last two variables to be optional, so that if they are not entered, the function assumes default values. Trying to use length of variable, but it's not working. In the end result, would like to be able to type in =test_function(=A1,,) and have it work the same is if I typed =test_function(=A1,200,63). Is there something else simple I can use to test if var2 and var3 have been entered?

Please Login or Register  to view this content.

Thanks

Change your first line to Function test_function(var1 As String, Optional var2 As Integer, Optional var3 As Integer)

Originally Posted by JieJenn

Change your first line to Function test_function(var1 As String, Optional var2 As Integer, Optional var3 As Integer)

Thanks! That works. Is there a simpler test I can do vs. Len(var2), like

Please Login or Register  to view this content.

Or similar syntax?

A "missing" number variable is considered with a value of 0. So as var2 and var3 are declared as integers, if they are omitted they are considered to be 0.

Please Login or Register  to view this content.

Which is fine, unless you also want to be able to pass 0 as a valid variable value... It may be better to declare those variables as variants, then you can check if they are numbers, and assign default values if not:

Please Login or Register  to view this content.

Got it! Thanks.