insert date and time picker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vernon Green - 01 May 2006 07:58 GMT

The Date and Time Picker is not available in the Control Box

Reply to this Message

David McRitchie - 01 May 2006 12:41 GMT

Hi Vernon,
To insert current date: ctrl+semicolon
To insert current time: Ctrl+Shift+colon
To insert current Date and Time: Ctrl+semicolon space ctrl+shift+colon

To enter automatically in a cell when you fill in another cell, you can use
an event macro;
DateTimeStamp in Column A, on first entry in any other column on row (#datetimestamp)
http://www.mvps.org/dmcritchie/excel/event.htm#datetimestamp
Worksheet Events are installed with the worksheet by right-clicking on the sheettab,
choose 'view code', and then paste in your macro.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> The Date and Time Picker is not available in the Control Box

Reply to this Message

Vernon Green - 01 May 2006 16:57 GMT

This n know
In the view Menu toolbars is a control box
If seleck this control box and ad it to the menu.
In this is a control box that you can choose more controls.
I had to reload my computer Prevuoisly in my control box there were a
Microsoft Date and time Picker Control. This enable me insert a date picker
into a cell

> Hi Vernon,
> To insert current date: ctrl+semicolon
[quoted text clipped - 14 lines]
>
> > The Date and Time Picker is not available in the Control Box

Reply to this Message

David McRitchie - 02 May 2006 02:49 GMT

Hi Vernon,
how about:
http://www.andrewsexceltips.com/my_utilities.htm

> This n know
> In the view Menu toolbars is a control box
[quoted text clipped - 3 lines]
> Microsoft Date and time Picker Control. This enable me insert a date picker
> into a cell

Reply to this Message