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.
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
