>Ok that is good but what if I have 543 calls to my function and none of the call has parameters.
>
>How can I make the optional parameter facultative?
adding a OPTIONAL argument to your method doesn't requires you to modify your 543 callers. It is optional (faculative) and you don't need to provide a value when you call the method.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com