How to check the existing of Optional object argument ?

A

Albert

Hi, I want to pass ADO Connection object to my procedure. But I want it as
Optional also. In VB help, it explains Optional apply to Variant data type
only. I can not use IsMissing() to test. So, I try checking the existing of
passing object by Is Nothing comparison. Although it works well, but I not
sure. Could you confirm me that my method is proper or not. Or have other
ways to check ?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Optional argument as Variant not acting like number 4
Object exists...and it doesn't 6
Optional Arguments in Sub Procedure 14
Optional arguments and IsMissing 2
User-Defined Type as Optional Argument 2
CDO-email 0
Compile error: Argument not optional 3
UDF: how to tell if optional *range* parameter is empty? 3

Top