Hi all, this is my first post so please do take it easy on me, I am not quite sure if I am asking the right question or am in the right spot so here goes. I am using Excel 2003.
I have a UserForm which I want to control the input of data into cells. I know I could use the DTPicker however not all users may have this functionality therefore they would not be able to use that. I also don't know how to get the DTPicker to default to the current date and time.
So what I was hoping is that someone somewhere has used 5 ComboBoxes, 1 each for Day, Month, Year, Hour and Minute on a userform to get the user to enter / select a date in a user form using named lists.
I would like the initial date and time displayed by the 5 combo boxes to be set as the current date and time. It also needs to do some form of validation to ensure the user has entered a valid date.
A perfect answer would be if someone could post an excel file with the userform included.
Thanks so much in advance and many apologies if I have not put this in the right spot.
I have a UserForm which I want to control the input of data into cells. I know I could use the DTPicker however not all users may have this functionality therefore they would not be able to use that. I also don't know how to get the DTPicker to default to the current date and time.
So what I was hoping is that someone somewhere has used 5 ComboBoxes, 1 each for Day, Month, Year, Hour and Minute on a userform to get the user to enter / select a date in a user form using named lists.
I would like the initial date and time displayed by the 5 combo boxes to be set as the current date and time. It also needs to do some form of validation to ensure the user has entered a valid date.
A perfect answer would be if someone could post an excel file with the userform included.
Thanks so much in advance and many apologies if I have not put this in the right spot.
