RibbonX Help

[Jaybe08]

On my ribbon, I have group that contains a button that opens a Calendar form and a label which will display a date. I want the user to select a date from the calendar which will then in turn update the label with the selected date. However, I'm not sure how to update the label with the user's selected date.

I'm new to Excel VBA and to the RibbonX.

I appreciate anyone's help on how to approach this problem.

 

[Ron de Bruin]

Try this in the click event of the calendar

Private Sub Calendar1_Click()
Me.Label1.Caption = Me.Calendar1.Value
End Sub