Public Functions (Optional Parameters)

[MNpoker]

I want to create a public function that has an optional parameter.

For example
Public function GetValue(A, B)

If B is not entered into the formula it defaults to 0.

Like in the Excel Function Beta where A and B are optional.

Anyone know how to do this?

Thanks!

 

[Seti]

Public Function GetValue(Optional A, Optional B)
If IsMissing A Then A = 0
If IsMissing B Then B = 0
.
.
.
End Function

 

[MNpoker]

Great Thanks!

 

[Norie]

If you want a default value.

Public Function GetValue(A, Optional B = 0)

 

[Seti]

Thanks Norie. Learn something new every day.