| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button Date/Time Stamp
I am trying to date/time stamp a cell by clicking a command button. I want
the cell to display the date and time when the button was last clicked. I can get it to display the date but I cannot figure out how to get "SendKeys" to allow me to select CTL+; "SPACE" CTL+ALT+; . This is what I have now as a command for the button and it will give me a date in the selected cell: Private Sub CommandButton1_Click() Range("c2").Select SendKeys "^(;)" End Sub -- skyknight |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions | |||
| Date and time stamp, control button | Excel Discussion (Misc queries) | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| How can i use a command button to validate date and time | Excel Discussion (Misc queries) | |||
| Date/Time Stamp Macro Button Problem | Excel Programming | |||
Threaded Mode
