Constants, user-defined types not allowed as Public members

[secici]

Hi!

I wanted to declare a user-defined type for easy-manipulation of some of my strings. And I also wanted them to be declared as "Public" so I can access them whereever needed. But My ExcelXP VBA tells me that

Constants, user-defined types etc. etc. are not allowed as Public members of object modules

On the other hand in the Help "const" topic it can easily be seen that there is no restriction on declaring public constants.

What is the background of this dilemma? Is it possible to overcome this problem of mine in a different way?
This message was edited by secici on 2002-11-02 07:05

 

[phantom1975]

Did you try declaring your constant in the Modules instead of a UserForm or worksheet?

 

[secici]

I think I' ve tried declaring user-defined data type in a module but it didn't work. But I'm not sure now. I'll take a look again.