I heart Excel
Board Regular
- Joined
- Feb 28, 2011
- Messages
- 66
Hello,
I have created a form where you can select the start date and end date, and also then seperatly the start time and the end time using ActiveX Controls.
I would like it to be able total -
Date - Number of days
Time - Number of hours
Once they have been selected, is there anyway this can be done in VBA?
Have had a look and there looks like there is a calculation option but I'm not sure how to select the ActiveX Control!!
Thanks
I have created a form where you can select the start date and end date, and also then seperatly the start time and the end time using ActiveX Controls.
I would like it to be able total -
Date - Number of days
Time - Number of hours
Once they have been selected, is there anyway this can be done in VBA?
Have had a look and there looks like there is a calculation option but I'm not sure how to select the ActiveX Control!!
Thanks