Datepicker deletion

[mmmreece]

Hi. I have a spreadsheet that I use on my phone, my laptop and several other computers. It's basically portable. The problem I have is that if the datepicker isn't present on a particular machine, Office 365 removes it. This means that when I go back to a machine that has datepicker installed it's been removed from my sheet. Is there some code that can prevent this happening?

 

[pbornemeier]

This post lists some alternatives to the now defunct datepicker:

Dt Picker Alternative [SOLVED]

I have developed a VBA Excel data entry solution which uses DT Picker. Unfortunately, due to hardware and software changes (Windows 10 and various versions of Office) that component (Dt Picker) is failing. From my "googling" research, it now appears that Dt Picker is not compatible with...

www.excelforum.com

 

[EdPeters]

I've created a UserForm to simulate the DatePicker calendar control. Tested on Office 365. Sample spreadsheet shows how the UserForm can be used to enter a date into the active cell OR used within another userform. Enjoy.

CalendarForm.xlsm

 

[mmmreece]

Thanks. Would've replied quicker but both Win 10 machines died on me the last few months so only just got one back. It wasn't a case of wanting to replace the datepicker but more of a method of detecting that the datepicker wasn't present on that computer and a routine to stop Excel automatically deleting it from all my forms when I try and load the spreadsheet on one of the computers that does have datepicker on.
The question's a bit mute now though as I had so many problems with Office 365 messing up with the autosave online thing that I only run the spreadsheet on one computer now and have written an autosave macro on so that you're no longer limited by the rather daft idea of "only autosave to cloud" being available.