Format number for time , hh:mm:ss,,,second appears 00

p45cal · #5 04-26-2021, 03:11 AM

Quote:

Originally Posted by rollis13

and assign it to a key combination.
Example: Ctrl+t (t for time

)

The user interface dialogue box (Alt+F8 from the keyboard) Options… button only allows you to use letters, you can (since you're already using macros) assign the same key combination you're used to using (Ctrl+Shift+colon) to that macro with:

Code:

Application.OnKey "+^:", "Data"

You could run that one-liner on workbook open, or when you activate that sheet, with the likes of:

Code:

Private Sub Workbook_Open()
Application.OnKey "+^:", "Data"
End Sub

in the ThisWorkbook's code-module,
or in the sheet concerned's code-module:

Code:

Private Sub Worksheet_Activate()
Application.OnKey "+^:", "Data"
End Sub

It's polite to restore the original functionality when you no longer need it which you can do with the one liner:

Code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "+^:"
End Sub

but for such a trivial change you probably don't want to bother; it'll be restored when you next open Excel anyway.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sequential Numbering A Document When The Same Number Appears Twice on a Page	Auxiliaryman COB	Word	3	08-02-2017 03:10 PM
Outlook - Recieved emails Sender address appears differnt each time	scotchtech@outlook.com	Outlook	0	02-24-2017 02:34 PM
How to format a TOC (level 1) using a number, but have the number hidden in the text	porpoiseoil	Word	1	09-13-2014 12:53 PM
1.image in a table 2.right click 3.menu click format 4.a format column appears	OldFatDog	Drawing and Graphics	1	06-13-2014 11:19 PM
Change from General Format to number format	gbaker	Excel	3	08-16-2013 01:04 PM