Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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
  #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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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

  #5   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?

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NEED TO MAKE THE PRINT BUTTON FUNCTION IN WORKSHEET dlc-forbes Excel Worksheet Functions 2 April 9th 06 01:11 PM
Button or key to conditionally change text foreground color? Alex New Users to Excel 1 February 27th 06 09:40 PM
Combo Box David French Excel Worksheet Functions 0 October 3rd 05 06:02 PM
How can I make the save button available from the openoffice? Rod Excel Discussion (Misc queries) 2 September 24th 05 06:46 PM
Command Button VBA code Dave Peterson Excel Discussion (Misc queries) 2 January 25th 05 11:28 PM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"