Our training courses

Other training resources

Our training venues

Why we are different

Details for DBlakeMAAT

DBlakeMAAT has participated in the following threads:

Added by DBlakeMAAT on 18 Aug 2019 at 14:33

Hi Andrew

Love the way you teach and the videos, they are always my go to point and have allowed me to do some great things!

My question is on using User Defined Type Declarations with class modules (specifically property statements), I have a large number of private fields in my class module (SupplierASearchString, SupplierAWorksheet, SupplierBSearchString, SupplierBWorkSheet etc etc). I am thinking of trying to simplify this by using User Defined Types (UDT), thus allowing me to have a single Private Field per supplier declared using my UDT.

It would appear that you can not declare property statements for the individual elements of a UDT.  Not all of my elements are set at the same moment in the procedures that i am running, would this mean that UDT are probably not the best approach or am i missing something fundimental with regards to UDTs? 


Many thanks 


Dave Blake MAAT

Head office

Kingsmoor House

Railway Street


SK13 2AA


Landmark Offices

99 Bishopsgate




Holiday Inn

25 Aytoun Street


M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...