How can I make a clickable button to do a Key Combo?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Using Excel 2003
 
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
 
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
 
You're very welcome........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3
 
You're very welcome........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can UDF return a customized hyperlink? 3
Creating a clickable button 2
How do you make a double clickable link? 3
make hyperlinks clickable in header 2
disable a button until a link is clicked 3
Clickable Cells 2
Auto recalculate? 3
indirect referencing cells with hyperlinks brings text not link- any solution? 4

Back
Top