Formatting a row to insert current date and time on demand

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MorseCode - 16 May 2008 23:56 GMT

I would like to have an icon to select that will insert the current date and
time. I attempted to make a macro to accomplish this and it worked great
UNTIL I figured out that every time I entered a new date, it changed them
ALL.

I need for the date and time to be possibly different. When I use Ctrl + ;
I get the date then space once and use Ctrl + Shift + ; and you get the time.
This works great however I dont want to do this every time I need this data.

PLEASE HELP!

Signed Frustrated in SC....

Reply to this Message

JE McGimpsey - 17 May 2008 00:59 GMT

One way:

Public Sub InsertDateAndTimeInActiveCell()
With ActiveCell
.Value = Now
.NumberFormat = "dd mmmm yyyy hh:mm:ss"
End With
End Sub

> I would like to have an icon to select that will insert the current date and
> time. I attempted to make a macro to accomplish this and it worked great
[quoted text clipped - 8 lines]
> :(
> Signed Frustrated in SC....

Reply to this Message