Loading Custom Data Type ?

I have the following simple, custom data type:

Please Login or Register  to view this content.

And now I want to be able to simply load it from a sheet, e.g.,

Please Login or Register  to view this content.

But it does not work. If I throw away my custom data type and just DIM command as variant, it works fine.

So, how can I load the data SIMPLY, but be able to refer to it using the dot syntax of custom data types?

**** Penny
PS. did I do the code tags correctly this time?

Is it possible to have an "equivalence" (as in Fortran)(and I think C) for custom data structures?

I want to be able to fill a data structure from cells on a sheet as a variant because I can do it in one line of code.

Please Login or Register  to view this content.

But I want to use/refer to it using the dot syntax of a "user defined" data structure instead of two sub-scripts, i.e. (2,3).

Please Login or Register  to view this content.

Can I do this? What is the syntax?

**** Penny

Hello ****,

I covered this in the answer to your last post...

Equivalence or Alias of Custom Data Types

Sincerely,
Leith Ross

Leigh,

1st, thanks for monitoring this forum & your recent answers.

BUT, you missed my point completely - I guess I'm not good at explaining, will try again.

I want to load a custom data structure with one statement similar to the way one does with a variant, e.g.
x = range.value
This creates a two dimensional structure in x for rows & columns respectively.

Now I want to access x using dot notation, e.g.
y = x(2).height

Can this be done, if so, exactly how?

****

Mike - Exactly what I had in mind.

THANKS