Date picker across different Office versions

[picklefactory]

Hi folks
I know this is a recurring subject, but my searches have not provided me an answer to my particular issue. I'd like to put a date picker in a userform, nothing new there, but my issue is that I need this wb to be available on 4 different pc's, unfortunately though, 2 of them are on Office 365 and the other 2 are on Office 2010. Does anyone know a way I can work a date picker that would work on all 4 machines please? Or am I being daft and that wouldn't be an issue?
Thanks

 

[Herakles]

Thank you Herakles, I'm perfectly happy to give it a try if you don't mind?

Try this workbook.

DatePicker.xlsm

Let me know if you cannot download it.

One form, one standard code module and one class code module.

modDatePicker
frmDatePicker
clsDatePickerClass

Change code where indicated in modDatePicker.

You can run the form as is using the current month as a default or change the settings in modDatePicker.

If you have any improvement suggestions then just let me know.

I'll explain later how one can incorporate this into any userform.

 

[picklefactory]

Try this workbook.

DatePicker.xlsm

Let me know if you cannot download it.

One form, one standard code module and one class code module.

modDatePicker
frmDatePicker
clsDatePickerClass

Change code where indicated in modDatePicker.

You can run the form as is using the current month as a default or change the settings in modDatePicker.

If you have any improvement suggestions then just let me know.

I'll explain later how one can incorporate this into any userform.

Thanks Herakles. Downloaded OK, and seems to be functioning although Sheet1 just has some weirdy stuff on it, but when I run the module I get a working datepicker. I'm a bit strapped for time right now, but I'll have a proper dabble over the weekend and report back.

 

[Herakles]

Thanks Herakles. Downloaded OK, and seems to be functioning although Sheet1 just has some weirdy stuff on it, but when I run the module I get a working datepicker. I'm a bit strapped for time right now, but I'll have a proper dabble over the weekend and report back.

Just delete everything on Sheet1.

It doesn't read from or write to the worksheet.

I forgot to say run it from subMain in modDatePicker but I'm sure that you have sussed that out.

 

[picklefactory]

Just delete everything on Sheet1.

It doesn't read from or write to the worksheet.

I forgot to say run it from subMain in modDatePicker but I'm sure that you have sussed that out.