Type Variables vs Class Modules

[NauticalGent]

Excellent article!

The VBA Type - VBA Custom Type alternative to Class - Analyst Cave

The VBA Type tutorial. Learn how to create custom VBA data types instead of classes. Group variables into a new custom VBA data structure. VBA Type Tutorial

analystcave.com

 

[The_Doc_Man]

I have used TYPE many times. It is sort of a compromise between a bunch of isolated variables and a more formal Class object, the main difference being that things declared via TYPE have fields but no special properties. They also have no inherent methods. The down side is that as a complex structure, you can't store them in a recordset in the TYPE form. But you COULD store the individual fields within the TYPE as fields in a recordset. Note that this differs from VBA file usage, where you can create a formatted file consisting of TYPE blocks.

 

[dataluver]

They are great for modeling data structures and I use them when I can, but the problem is that I can't store them in a dictionary or collection. In these cases, I usually end up using a class. Since UDTs are a value type, I suppose that they are faster than class objects? In other languages this is the case, but I don't know about VBA.

 

[MajP]

I like them with functions where you do something like find a record in a recordset and you want to return a couple pieces of information instead of just one. So instead of doing a bunch of dlookups you can have the function return a bunch of data about that record.

 

[MajP]

Here is an example to a bizarre problem

Regex

Hi, How can i calculate this in Via? 2(2A2B)= 4A 4B And 2(2A2B) = 8 Tk u

www.access-programmers.co.uk

 

[NauticalGent]

Here is an example to a bizarre problem

Regex

Hi, How can i calculate this in Via? 2(2A2B)= 4A 4B And 2(2A2B) = 8 Tk u

www.access-programmers.co.uk

I followed that thread. Impressive solution you offered.