ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I make a clickable button to do a Key Combo? (https://www.excelbanter.com/excel-worksheet-functions/106230-how-can-i-make-clickable-button-do-key-combo.html)

BGerman

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

Using Excel 2003

CLR

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


BGerman

How can I make a clickable button to do a Key Combo?
 
Perfecto! Muchas Gracis por tu ayudar, mi amigo.

¡Dios le bendiga!
BGerman

Enjoy www.livingwaters.com

"CLR" wrote:

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


BGerman

How can I make a clickable button to do a Key Combo?
 
Perfecto! Muchas Gracis por tu ayudar, mi amigo.

¡Dios le bendiga!
BGerman

Enjoy www.livingwaters.com

"BGerman" wrote:

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

Using Excel 2003


CLR

How can I make a clickable button to do a Key Combo?
 
You're very welcome........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"BGerman" wrote:

Perfecto! Muchas Gracis por tu ayudar, mi amigo.

¡Dios le bendiga!
BGerman

Enjoy www.livingwaters.com

"CLR" wrote:

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



All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com