Chapter 11. Making the Complex Simple: Creating Your Own Data Types

After 10 hours, you get a break. This hour is “shorter” in terms of text, but it is a significant hour in terms of content because Hour 11 is a precursor to advanced programming topics. This hour covers the user-defined type.

The type declaration—referred to as a record in some languages—was an early attempt at data aggregation. Early programmers discovered that sometimes it was more convenient to think of many pieces of individual data as one aggregate of data. Even though objects hit the mainstream in the early 1990s, the VBA Type construct is still relevant today.

User-defined data types are still in use today. Sometimes you might need to create a new type that contains many ...

Get Sams Teach Yourself Microsoft now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.