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!