My property set statement has an arglist because the matching get statement has args and the rule is let/get have the same args, but with let having +1.

How can I assign the let property in the code?

EG - Public Property Set Category(ByVal Var1 As String, _
 ByRef Var2 As Variant, ByRef Var3 As Variant,ByRef Var4 As Variant, ByRef Var5 As Variant, ByVal rsNewValue As ADODB.Recordset).


In the calling code, how does the set statement look?

I can't do Set object.Category = rsCategory... VB errors out with the runtime error, "Argument not optional."

There are NO examples out there save for single variable sets. HELP!!!

If I understand you correctly, the only reason you are passing the parameters Var1, Var2, etc. is because those parameters exist in the matching Get statement, Get Category(). It looks like the objective of your Set property is to update a database or something of that nature.

If this is true then this may help you.

You are not required to have a "matching" Get\Let\Set statements. You can use the Get Category() property by itself without using a related Let or Set property. Then create a public function, such as SetCategory(ByVal rsNewValue as ADODB.Recordset), named to your liking.

To return the property values call your Get Category() property and to set the values call the SetCategory() function.

Hope this helps you,



Larry Asher

Public Property Set Category(ByVal Var1 As String, _
 ByRef Var2 As Variant, ByRef Var3 As Variant,ByRef Var4 As Variant, ByRef Var5 As Variant, ByVal rsNewValue As ADODB.Recordset).

You call it by

Set a(var1, var2, var3, var4, var5) = rsNewValue

Doesn't this look like an array to you? If your property requiring multiple paramters and those parameters are not dimisions of array then you should write them as sub and functions.