date on the userform

[walid66]

here is my situation. I have this userform it is working fine so far accept for two things. One when I click on the calendar (bottom right) to select the date for shedule date it works fine but when I do the same thing on the requested date but selecting different date I still get the same date as the shedule date. I want to have different date on the requested date from the schedule date. Is this possible? the second one is the start time I want the start time to appear when I launch the form. the form and the code are attached.

Thanks

[davesexcel]

instead of using a general calendar, you could use
Microsoft Date and Time Picker Control, in place of the textboxes
when in edit for your userform, right click on the toolbox ans select additional controls
find
Microsoft Date and Time Control and hit the select box, then OKAY or whatever to apply the addition
Then you have that new control, in the toolbox, replace the date textboxes with the date picker control
Lots of info on Date and time picker for excel if you google it

[royUK]

One thing to be aware of withe date and timepicker is that it is not always available, some end users might not have it on their machines.

[davesexcel]

One thing to be aware of withe date and timepicker is that it is not always available, some end users might not have it on their machines.

Right, and it sucks if somebody on another computer, accesses the workbook from a network that doesn't have the controls, when they save the workbook, the controls are lost, and people start wondering where the controls keep disappearing to.....
anyway make a control part of the workbook?

[Norie]

walid

Why are you surprised by this?

That's what you are telling the code to do.

Perhaps something like this would be better.

Please Login or Register  to view this content.

[royUK]

Change your code to this

Please Login or Register  to view this content.

[walid66]

Thanks guys that really helped. Is there a time picker that I can use to pick a time similar to the date picker for the start time field?

[walid66]

I figured out the time picker.

Thanks again.

[Norie]

walid

Do you realise you could replace the existing textboxes with date/time pickers?

Perhaps that's what you've already done.