View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Multi-level User Definet Types

Can you create a UDT with multiple levels of depth?

For example, if I had user defined type called house with the sublevels
shown below, would I be able to dim House1 as house and have a multi-layered
UDT so that I could call values like this House.MasterBedroom.Height or
House.DiningRoom.Breadth?

I'm not sure if this explains what I'm asking, but it's the best example I
can think of. Below is the structure for the UDT that I am imagining. Is it
possible to have a UDT that is more than one layer deep, with elements and
sub-elements?

House
-MasterBedroom
---Breadth
---Depth
---Height
---Flooring
---PaintColour
-Guestroom
---Breadth
---Depth
---Height
---Flooring
---PaintColour
-LivingRoom
---Breadth
---Depth
---Height
---Flooring
---PaintColour
-DiningRoom
---Breadth
---Depth
---Height
---Flooring
---PaintColour
-Bathroom
---Breadth
---Depth
---Height
---Flooring
---PaintColour