capture date and time through Userform in Excel VBA

[Alok Bajaj]

Hi,

I have designed a form and need to capture a prior date & time using the form.
I tried using DTpicker, but I am able to select only date and it takes the current system time.
If I change the format to dtptime, I am able to select time but it captures today's date.

I should be able to select date and time on my own.
Eg : if now() = 7/23/12 08:44 PM
I should be able to select 7/15/12 11:10 AM

How do I achieve this ?
Please help

Thanks,
Alok