ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding time selection to pop-up calendar (https://www.excelbanter.com/excel-programming/355255-adding-time-selection-pop-up-calendar.html)

RMF

Adding time selection to pop-up calendar
 
Dear excel users,

I have found the calendar tool on http://www.fontstuff.com/ and it works
excellent. In addition to date I would like to include the possibility to
select the time. Unfortunately I am not so advanced in VBA and therefore I
would like your help with this one.

So besides selecting the date, I also want to include time in the cell so
the cell would look like this for example: 21-03-2006 15:30. I only need be
able to select times with 30 min. intervals so I only need 09:00, 09:30,
10:00, 10:30 and so on.

Any help is highly appreciated!

RMF



Ron de Bruin

Adding time selection to pop-up calendar
 
Hi RMF

You can use the Date Time picker for this
http://msdn.microsoft.com/library/de...e/datetime.asp


--
Regards Ron de Bruin
http://www.rondebruin.nl


"RMF" wrote in message ...
Dear excel users,

I have found the calendar tool on http://www.fontstuff.com/ and it works
excellent. In addition to date I would like to include the possibility to
select the time. Unfortunately I am not so advanced in VBA and therefore I
would like your help with this one.

So besides selecting the date, I also want to include time in the cell so
the cell would look like this for example: 21-03-2006 15:30. I only need be
able to select times with 30 min. intervals so I only need 09:00, 09:30,
10:00, 10:30 and so on.

Any help is highly appreciated!

RMF






All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com