Calendar on Sheet and userforms

Good day,
I was just wondering if it would be possible to add one calendar instead of multiple calendars that would do the same functions but to add the information also in a specific textbox or textboxes.

I have 5 main sheets that would use dates. I have a standard calendar in my VBE (frmcalendar).

I have multiple userforms and within these userforms I have multiple textbox that requires dates (Format preference “YYYY-MM-DD”).

I searched on some forum that it not possible to do so and that it had to have multiple calendars for each textbox that requires a calendar date stamp.

I have around 5 userform that in each userform will have 2 textbox that would require dates.

Frmne has 2 textboxes (Textbox3, textbox7) If there is a way to make my original calendar, that I’m using on my sheets, to generate the same information in my textboxes that would be awesome.

The test I made made it that each time I entered a date in textbox7 it would also insert the same date in textbox3.

I need that all of my textboxes within my userforms be separate information. Is there a code or explanation so I can have my Workbook function on only one calendar method and not 3?

Here is a test Workbook that use 3 calendar for testing. Just need to know if it is possible to use only one.

On Open Select New entry (Top left from Sheet).


Datetest.xlsm

Thank you jaslake but I need to keep it simple so that I can explain to another user if I am not there or leave the section how to and have a step by step guide (that I have already constructed). They all have the Microsoft Calendar Control. I find this way easier for me as one calendar controls the sheets and 2 calendar controls my textboxes within my Userforms. As I said, I only use 2 textboxes in a userform so that the data entry does not mix up the two and plus it's reserved only for my Userforms. Works well for me, just wanted to know a work around to use the same calendar for all (Sheets and Userforms).

Thank you all.

Thanks Jaslake for sharing this solution. It is working very well!