See first line...
"Die_Another_Day" wrote:

Range("A1") = Time 'Time only

Die_Another_Day
wildauk wrote:
yes that worked thank you, is there any way I can only have the time without
the date?

"Die_Another_Day" wrote:

Range("A1") = Time 'Time only
Range("A1") = Date & " " & Time 'Date And Time

HTH


Die_Another_Day

wildauk wrote:
Hi, I need a code for a button so when I press it the time is shown in say
cell A1 and it will not change untill I press the button agian.

Thank's inadvance, Barry.