Talking to a class or type between 2 sheets

[Torben Laursen]

Hi

I'm trying to write some VBA code that will let one sheet fill eigther a
user defined type or class with values,
and then I need a second sheet to be able to get that information.

The problem I have is that VBA will not let me declare eigther a class or
Type as public
and when I make it a property I get a run time error.
If I try to write a function so the second sheet can copy the type or class,
I also get errors

So can anyone show me how this is done?

Thanks Torben

 

[Tom Ogilvy]

http://groups.google.com/groups?as_...cel.programming&as_uauthors=pearson&lr=&hl=en

make the URL all one line (in notepad) and then paste in the nagivation box
of your browser. Chip Pearson has posted some good explanations and
examples on using classes for this type of thing.