View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sky Sky is offline
external usenet poster
 
Posts: 10
Default 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