Time Stamp with one key?

[SVTF]

Is there a way that I can time stamp a cell with h:mm?

With any one key instead of having to press ctrl+shift+; every time.

Perhaps a macro or something?

What would it look like?

Thanks in advance,

Wayne

[VBA Noob]

Try this

Right click the sheet tab > select view code > paste in the below

Then double click anywhere in the range A1 to A100

Please Login or Register  to view this content.

VBA Noob

[SVTF]

Try this

Right click the sheet tab > select view code > paste in the below

Then double click anywhere in the range A1 to A100

Please Login or Register  to view this content.

VBA Noob

Thank you for your quick response worked like a charm