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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bart,
It will work if you pass it like this instead: Public Sub PassRefTest(SomeForm As YourUserFom) SomeForm.myObject.myProperty = "myValue" End Sub NickHK "Bart" wrote in message oups.com... 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks again NickHK!
Somewhere I can see the logic of it, but wouldn't ever think of assigning this kind of Type! What about passing an other UserForm than 'YourUserForm'? And then which specifications does this UseForm need to have? Does it minimal needs to have the Variables declared at module level which eventually are used in the procedure? Bart |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, basically.
You could try passing a generic Object in the argument, although then you will lose all Intellisense. NickHK "Bart" wrote in message oups.com... Thanks again NickHK! Somewhere I can see the logic of it, but wouldn't ever think of assigning this kind of Type! What about passing an other UserForm than 'YourUserForm'? And then which specifications does this UseForm need to have? Does it minimal needs to have the Variables declared at module level which eventually are used in the procedure? Bart |
Reply |
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 |