VBA "With object" syntax - can you refer to the object itself? -


i use object syntax when i'm doing bunch of different stuff object. it's useful shorthand calling object's properties/methods without having clutter code reusing object's name. want call function takes argument object itself. there way refer object in case?

' class module ' class1  ' code module sub f(byref obj class1) end sub  sub test()   dim obj class1: set obj = new class1   obj     f me ' doesn't work - can refer obj in context?     f obj ' works don't when object has long name   end end sub 

no, there not. have use object itself, have done in code.


Comments

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

javascript - Complex json ng-repeat -

jquery - Cloning of rows and columns from the old table into the new with colSpan and rowSpan -