Passing non-variable object declaration

Question

I have a method which contains a ParamArray parameter and was wondering if there was some special notation i could use in VBA to get the same effect as:

method val1, _
         val2, _
         new object(){prop1:=val11, _
                      prop2:=val12}, _
         new object(){prop1:=val21, _
                      prop2:=val22}

Its not pretty but should get the point acrossed. Basically i am trying to translate the skills/logic i have learned to use in .Net, since 1.0, and try to incorporate a similar logic design in VBA.

Alex K. · Accepted Answer · 2012-10-10 14:54:42Z

1

Assuming you mean the object construction shorthand then no, there is no direct equivalent.

If the member names are the same then you could use a factory function

method val1, val2, makeFoo(val11, val12), makeFoo(val21, val22)
.
.
.
function makeFoo(prop1 as string, prop2 as string) As clsFoo
   set makeFoo = new clsFoo
   makeFoo.prop1 = prop1
   makeFoo.prop2 = prop2
end function

Optional params would allow named arguments too makeFoo(prop1:=val11, ...

edited Oct 10, 2012 at 14:54

answered Oct 10, 2012 at 14:39

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

GoldBishop Over a year ago

tyvm...i was hoping not to make a helper function but seems VBA hasnt developed over the last 20yrs.

Collectives™ on Stack Overflow

Passing non-variable object declaration

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related