date and time automation in userforms

[ed ayers315]

I have attached a worksheet with a user form I programmed. In the user form I need the users to plug in the date and time, alot of these. I am afraid this will be too much for the users and they wont use the from.

Is there automation available to put into the user form like excel date picker?

[royUK]

You can actually use the DatePicker to display time, set it's Format property to dtpTime.

However, using DatePicker controls can be problmatical, see

http://excel-it.com/free_addins.htm

Also, time example :
Combo_Time.zip

[Richard Buttrey]

Hi,

Not quite sure what you're asking. However if you're trying to ensure a valid date is picked, you could add three drop down List Boxes, one each for days,months and years, and have the user pick a value from each one. This will ensure you can construct a valid Excel Date 'number'.

HTH

[ed ayers315]

I down loaded and installed the date picker. I placed one formatted for the date and one next to it formatted for time. I can not find how to controlsource it so it shows the valve on the finished form. Is there code so when the user is in a text box to open the date or time picker and that valve would be the valve in the text box?

[royUK]

Which date & time picker?

[ed ayers315]

DTPicker from the tool add on list

Followup note:

I have tried a number of the suggested dat pickers and other ideas like macros and not found a solution. I the userform1; you can see that there are 38-40 places where the user could need to add the date and time