Calendar control - pick date and time

Nilam

Board Regular
Joined
Feb 12, 2004
Messages
58
Hello all

I know it is possible to implement calendar control but is it possible to pick date and time at the same time in a pop up box (to display in selected cell).

Thanks

Nilam
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Oh - just noticed the "and time" bit... gonna need a user form, I think...

Nope, I was wrong. You don't need a UF. You can do it with an ActiveX. At least w/ Excel 2003, there is a "Microsoft Date Time Picker". Just drop it on the worksheet and open the Properties Dialog and alter the format to be a time picker. You'll have to watch the value in the linked cell, though as it's defaulting to today's date to it on me.
 

Watch MrExcel Video

Forum statistics

Threads
1,112,796
Messages
5,542,552
Members
410,560
Latest member
1ndependent
Top