[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1757
  • Last Modified:

Excel: Pop up Calendar and Clock

Hi,
Variation in data manually entered into an Excel file causes defects and is time consuming. I am looking for a code that can pop up a window with
calendar and numeric clock where a user can click and choose values which then will be entered into a cell selected by cursor,  in a format "mm/d/yy h:mm AM/PM;@".
I found this link http://www.fontstuff.com/vba/vbatut07.htm with a calendar solution, but could not find both as one utility.

Tks, N
0
NewToVBA
Asked:
NewToVBA
2 Solutions
 
byronwallCommented:
You can make use of the "Microsoft Date and Time Control" using a custom format of "MM/dd/yyyy HH:mm".  This could be employed with several different methods.  It will give you a drop down calendar for selecting the data and the time fields for entry as well.

See the attached workbook which has the popup activate on CTRL SHIFT Q.

 date-pop-up.xlsm
0
 
wellousCommented:
Hi,

Yes , you can do it with date /time as per my attachment ...
Click on cell B2 and tell me if you like it.
Cheers,

Wellous
date-timepickerver1-1-.xls
0
 
NewToVBAAuthor Commented:
Well Done!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now