Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
The Date and Time Picker is not available in the Control Box
|
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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...#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 "Vernon Green" <Vernon wrote in message ... The Date and Time Picker is not available in the Control Box |
#3
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 "David McRitchie" wrote: 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...#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 "Vernon Green" <Vernon wrote in message ... The Date and Time Picker is not available in the Control Box |
#4
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Hi Vernon,
how about: http://www.andrewsexceltips.com/my_utilities.htm "Vernon Green" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem in date time picker size | Excel Discussion (Misc queries) | |||
automatically insert date and time into excel] | Excel Discussion (Misc queries) | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
Date and Time Picker Control problem | Excel Discussion (Misc queries) | |||
Date and Time Picker Control | Excel Discussion (Misc queries) |