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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button Date/Time Stamp
Hi Sky,
Try: '============= Private Sub CommandButton1_Click() ActiveCell.Value = Format(Now, "mm/dd/yy hh-mm") End Sub '<<============= --- Regards, Norman "sky" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button Date/Time Stamp
Private Sub CommandButton1_Click()
Range("c2").Value = Now() End Sub -- HTH... Jim Thomlinson "sky" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button Date/Time Stamp
Thanks Guys
I finally also came up with my own less elegant one. =========== Private Sub CommandButton1_Click() Range("c2").Select SendKeys "^(;)" SendKeys " " SendKeys "^+(;)", Wait End Sub ========= skyknight |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button Date/Time Stamp
Hi Sky,
I finally also came up with my own less elegant one. Elegance is in the eye of the beholder, but why use a clunky implementation of SendKeys when a native function is available? --- Regards, Norman "sky" wrote in message ... Thanks Guys I finally also came up with my own less elegant one. =========== Private Sub CommandButton1_Click() Range("c2").Select SendKeys "^(;)" SendKeys " " SendKeys "^+(;)", Wait End Sub ========= skyknight |
Reply |
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 |