>>x = class1.property1
>>y = class2.property1
>>....
>>Maybe, I am barking up the wrong tree and class mods are not the best way achieve this result. Any input is good input.
>>
>>Thanks in advance,
>
>Using the class builder (found in the Add-ins manager) I generate this code in no-time for you!
>
>Try this:
>
>Option Explicit
>
>'local variable(s) to hold property value(s)
>Private mvarTargetDir As String 'local copy
>Private mvarTargetFile As String 'local copy
>Private mvarSourceDir As String 'local copy
>Public Sub MyActionExecution()
>End Sub
>
>Public Property Let SourceDir(ByVal vData As String)
>'used when assigning a value to the property, on the left side of an
.
.
.
>'Syntax: Debug.Print X.TargetDir
> TargetDir = mvarTargetDir
>End Property
>~Joe Johnston USA"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams