Help : Date Picker in VBA user form and view data from data entry wb

[anish.ms]

Dear Experts,

Request your help on the below-

I have a user form wherein three places I need to fill dates from a calendar. I have included a Calendar Control Class downloaded from here (https://sites.google.com/site/e90e50/calendar-control-class) and I managed to use it in one text box (colord in green). Request your help in using the same calendar in rest of two places (colord in yellow).

28316
28317

I would also request, if you can support me in viewing the results from Data entry sheet based on the criteria selection in report section.

Really appreciate any support
Thanks!

[SamT]

Dim SelectedBox As MsForms.Control 'Or something like that

Sub ReviewDate_Click() 'Repeat for each Box.
'something like this
Set SelectedBox = ReviewDate
Show Calendar Control
End Sub


Calendar_Click
'something like this
Selected Box.Value = Calendar.Value
Set SelectedBox = Nothing
Calendar.Close
End Sub

[anish.ms]

Thanks Sam for your time and response!
Let me try and revert.