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

http://groups.google.com/groups?as_q...rson&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.

--
Regards,
Tom Ogilvy

"Torben Laursen" wrote in message
...
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