asked on

Set Class Property

I am trying to program a calendar and have created a class for the day buttons which captures the Click event for any of them. For the purpose of handling this event on class level I would like to create a Parent property for the buttons and assign the UserForm to it. This is the code I have,
in the class module 'CalButton'

    Public WithEvents CalBtn As MSForms.Label
    Public pParent As DatePicker

    Public Property Get Parent() As DatePicker
        Set CalForm = pParent
    End Property
    Public Property Set CalForm(CalForm As DatePicker)
        Set pParent = CalForm
    End Property

Private Sub CalBtn_Click()
    MsgBox CalBtn.Name & " was clicked."
    Debug.Print CalBtn.Parent.Name                  ' DOESN'T WORK
End Sub

Open in new window

in the code module of the UserForm (DatePicker - no relation of the Excel form by the same name)

    Dim Btn() As CalButton

Private Sub AssignCalButtons()
    ' assign all day button to CalButton class

    Dim Ctl As Object
    Dim i As Long

    ReDim Btn(1 To Me.Controls.Count)
    For Each Ctl In Me.Controls
        If InStr(1, Ctl.Name, "Day", vbTextCompare) = 1 Then
            i = i + 1
            Set Btn(i) = New CalButton
            Set Btn(i).CalBtn = Ctl
            Set Btn(i).Parent = Me                      ' Compile error: Invalid use of property 
        End If
    Next Ctl
    ReDim Preserve Btn(1 To i)
End Sub

Open in new window

The code runs and works without the Parent property idea. What am I doing wrong, and how to do it right?

SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Faustulus

ASKER

Yes. You are right. The Parent property is available in the code I have as well. I had tested that first and it failed for reasons I now can't find out. That's why I tried to assign the form as a property to the class. That failed, too. That is why I tried to assign it to the Parent property.
OK. The problem is solved. But can you tell me how I can assign the form as a property of the class?
I have been testing this:
In the class module,

    Public pCalForm As MSForms.UserForm
    
    Public Property Get CalForm() As MSForms.UserForm
        Set CalForm = pCalForm
    End Property
    Public Property Set CalForm(Cal As MSForms.UserForm)
        Set pCalForm = Cal
    End Property

Open in new window

And in the code (actually, the form's code module)

    Set CalButton.CalForm = Me

Open in new window

It stops at CalButton and claims "Variable no defined".
Happy New Year!
Faustulus

Pavel Celba

This could mean either CalButton or CalForm is undefined.

Faustulus

ASKER

CalButton is the name of the class module.
CalForm is defined in the code I posted which is in the class module CalButton.
Where is the mistake?

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Faustulus

ASKER

Thank you. Your support was was a great relief to me in my hours of trial (and error).

Pavel Celba

You are welcome!

BTW, I don't use VB.NET at all. It seems I should install VS finally.

Happy New Year!