Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
'** In MyClass.cls
Private XLUForm As UserForm Public Property Set XLUserForm(vData As UserForm) Set XLUForm = vData End Property '**Called from a userform called MyForm Set MyClass.XLUForm=MyForm Using the above code in a class in same WB as the passed UserForm, vData.Caption always evaluates to "". But if, whilst in the class, I test ?MyForm.Caption it returns the correct value. Also, properties like vData.Width are no longer "supported", but ..InsideWidth is. If I change the declarations to: Private XLUForm As MyForm Public Property Set XLUserForm(vData As MyForm) everything is *normal*. Anyone explain why ? NickHK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to reference win.caption, when caption changes | Excel Programming | |||
Userform Caption | Excel Programming | |||
How to format Userform caption? | Excel Programming | |||
Source of value passed to class object | Excel Programming | |||
UserForm Caption | Excel Programming |