Userfor time selector...

[RobbieC]

Hi there, I have a userform and I have a textbox for a 'time input'. At the moment it just works as a text input box...

But I'd like to make it more dynamic...

Is there a nice way to add a time picker which will add the time into the textbox for me?

Any suggestions would be gratefully received

Thanks

 

[royUK]

There are Time & DatePickers in some versions of Excel, but they can be problematic.

Here's an example created on a UserForm

VBA TimePicker

 

[FaridWahidi]

Hi robbiec,

You may use VBA Date Picker

Please download my sample at the following path
https://app.box.com/s/wpjo9z2cgayyugs56lqwumvpc7mooaaf

However, it is not available on 64 bit version. I have a copy of file to activate in 64 bit version.

Please read this link, if you are interested.
https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/

 

[royUK]

The DatePicker that is in the addin is the one that I referred to. It is an activeXDatePicker control which is problematic because it is not always available in Excel, I get an error because the ActiveX DatePicker is not available in my version of Excel.

 

[FaridWahidi]

Hi All,

Here is the file and guide to activate DatePicker activeX in 64 bit version.
https://app.box.com/file/237981994537


I am also using 64 bit version and have created Userform Multipage with 29 Set of DatePicker.
So far no issues and all Pop-up calender date working fine.