View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default How can I make a clickable button to do a Key Combo?

Create any drawing object form the Drawing Toolbar, and assign this macro to
it......

Sub TimeStamp()
ActiveCell.Value = Format(Time, "h:m ampm")
End Sub


Vaya con Dios,
Chuck, CABGx3




"BGerman" wrote:

I want to make a clickable button to do a time stamp Key Combo of
"Ctrl"+"Shift"+";".

Using Excel 2003