DRJ
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 3,853
I want to have a date and time inputted onto a user form. I use a calendar control which is great. I was wondering if there was a time control. Something like what is brought up when you adjust the system time on the PC. The user can adjust the clock and the userform would received the appropriate time.
Also is there any way to send data when a user form is called? Right now I have 4 seperate userforms with a calendar control on it 'cause I need the data to go to different locations depending on which form was used, but all the forms are the some so if I could call it with a number then I could just use a case select to tell it where to put the data.
Thanks
Also is there any way to send data when a user form is called? Right now I have 4 seperate userforms with a calendar control on it 'cause I need the data to go to different locations depending on which form was used, but all the forms are the some so if I could call it with a number then I could just use a case select to tell it where to put the data.
Thanks