Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Type in a class module...
Hi.
This is an excerpt from the Help files: "In standard modules and class modules, user-defined types are public by default. This visibility can be changed using the Private keyword." This is very curious (and mysterious?) because I want to declare a public type in a class module and the VBE protests. Anybody in the know? Darek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Type in a class module...
I'd say the Help document errs.
Why do you want a public user-defined type in a class module? Any element of a private user-defined type could be "made public" via public Property Let and Property Get statements of the class. Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Type in a class module...
Indeed help is misleading, but no can do. It makes sense, your own UD type
in a class module would cause serious compile problems when used elsewhere until an instance of your class exists, not to mention the possibility of multiple instances of the same class. Same goes for public constants and declares. However I've never quite understood why a normal array can't be public in a class. Regards, Peter T "darlove" wrote in message oups.com... Hi. This is an excerpt from the Help files: "In standard modules and class modules, user-defined types are public by default. This visibility can be changed using the Private keyword." This is very curious (and mysterious?) because I want to declare a public type in a class module and the VBE protests. Anybody in the know? Darek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RefEdit in Class Module Problem | Excel Programming | |||
Class Module Problem | Excel Programming | |||
User-defined type collection in class module | Excel Programming | |||
Userform with template class module problem | Excel Programming |