Missing calendar control

Actually, I think I'm going to keep your solution, the datepicker you sent me. I've already copied it and put it in my userform, I just need to make it populate the next empty cell in column A. Do you have any idea with what you sent me? With this, my stats form would be complete.

Thanks again for your help.

Jean-François

Shall we try with an image?

I admit I don’t have anything better to offer you...
https://www.youtube.com/watch?v=9aspCSDVeKI

I hope you speak English; if not, there are always the images ;-)

(1) Effectuez la fonction ci-dessous sur tout ordinateur manquant le mscomct2.ocx.
(2) Assurez-vous qu'une copie se trouve dans C:\Windows\SysWoW64
(3) Cliquez sur le bouton Démarrer de Windows 7 et, dans la zone de recherche, tapez "command"
(4) La recherche affichera un certain nombre d'éléments, y compris "Invite de commandes" en haut
(5) Faites un clic droit sur la bannière "Invite de commandes" et sélectionnez "Exécuter en tant qu'administrateur"
(6) À l'invite de commandes, entrez : %systemroot%\SysWoW64\regsvr32.exe mscomct2.ocx
(7) Cela devrait enregistrer le contrôle avec succès.

ce que j'ai fait

The module was loaded but the call to DllRegisterServer failed with error code 0x8002801c.

If I remember correctly, there was a swap to be made between 32 and 64:
I placed my MSCOMCT2.OCX file in the SYSWOW64 directory and launched the CMD.exe program as an administrator.
I typed the command regsvr32 MSCCOMCT2.OCX and it all succeeded.

But I've become used to working with the independent calendar that I sent you.
If you want an example of a form where it is adapted to help you make your own adaptation, let me know, and I'll send you a file where by double-clicking in the textbox in a userform you generate the calendar.

I totally understand you!!!!
I remember struggling to install this control
were you able to run regsvr32?

Thank you,

But I'm still getting an error message that says the save failed in the control.

LOL it's in moments like these that I miss XP.

HERE IS THE MSCOMCT2.OCX FILE:

https://www.cjoint.com/c/FBBu0tgDlM6 (ActiveX control)

https://www.cjoint.com/c/FBBu1abYX56 (info)

Good evening Mag

I tried this procedure but the MSCOMCT2.OCX file is not present.

And I'm using Windows 10

But I will try what you attached, thank you for your time.

Jean-François

Good evening,
I had the same issue with Windows 8
since then I've switched to Windows 10 and managed to recover those missing controls thanks to this procedure:

https://support.microsoft.com/fr-fr/help/2676583

In the meantime, I was using an independent calendar that adapts to the text boxes in the userform = see attached file.
https://www.cjoint.com/c/FBBuc1zE3k6
Have a good evening
Mag