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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.735 / Virus Database: 489 - Release Date: 06/08/2004