[RESOLVED] Expected Expression. Optional Arguments

[cl1nch]

Hi, I hope someone can help me.
I'm getting an error whenever I try to do this.

Here is my code:

Sub emp_filter(Optional ByVal cmbApprove As ComboBox = Nothing, Optional ByVal cmbDept As ComboBox = Nothing)
...
End Sub

I call it like this,
This works: Call Class1.emp_filter( ,cmbdept)

This doesn't: Call Class1.emp_filter(cmbApprove, ) <------------ Here is where i'm getting the error "Expected Expression"


Is there a workaround for this aside from writing a new sub?

Thanks!

[jmcilhinney]

You only include the comma before an argument. If you're omitting the first argument and supplying the second then you need the comma to show that the first argument is empty. If you're supplying the first but not the second then you don't need and, in fact, cannot use the comma. The compiler assumes that the first argument is for the first parameter because there's no comma before it, so there's no need to indicate that the second argument is empty.

In short, get rid of the comma in the second code snippet.

[cl1nch]

Awesome!
Thanks jmcilhinney