I have made a procedure in a module like this:

Public Sub UpdateList(FileName As String, lstHolder As ListView, Data1 As Variant, Optional Data2 As Variant, Optional Data3 As Variant, Optional Data4 As Variant, Optional Data5 As Variant, Optional Data6 As Variant)

Wherever this sub is called from, it must contain atleast DATA1. I want to know in my module, as to which optional data was also requested by the user...

Eg user requested: Updatelist(MyFileName, MyListView, Data1,Data2,Data3)

How do i get to know in my module that the user did NOT request Data4, Data5 and Data6  

Regards

____________________________
lOsT...

Hi
Give your optional variables a default value.
I've found that the function "IsMissing" is unreliable, so give a default value of "null" or something.
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)