Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
On module level of an UserForm there's a variable declared as a certain Class (User Defined). When passing a pointer of this UserForm to a Subroutine in a Module and try to access the variable by this pointer, it says the Object doesn't support this Property or Method. Why can't I access the variable by using a pointer of a UserForm? Example: [General] Public myObject as myClass [Sub] Public mySub(ByRef myPointer as MSForms.UserForm) myPointer.myObject.myProperty = "myValue" End Sub Regards, Bart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Class modules: parametrize class object fields | Excel Programming | |||
PROBLEM: Keywords;= Userform, Class Modules, ButtonGroup and Nomenclature | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming | |||
Class Modules vs Modules | Excel Programming |