Thread: Command Button Date/Time Stamp
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Sky Sky is offline
external usenet poster
  
Posts: 10
Default 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



Reply With QuoteReply With Quote