Date stamping a cell

[terryainsley]

Is there a way to put a date stamp in a cell.

IE when cell D2 has any text/numbers entered into it. Cell C2 will put the current date in it and never change.

Thanks

[VBA Noob]

See link

http://www.mcgimpsey.com/excel/timestamp.html

VBA Noob

[terryainsley]

I'm useless,

Can't get it to work. I think i need everything hand fed

The cell I want the date in is, C2 if any text is entered in d2

[VBA Noob]

Try attachment. Uses the code. Right click sheet and select view code

VBA Noob

[terryainsley]

can't download file, says access is denied.

again

[VBA Noob]

Do this

Right click sheet name > select view code > paste in the below code > Close VB editor

Please Login or Register  to view this content.

VBA Noob

[terryainsley]

Thanks,

but when i enter text I just get loads of #########

The cells are formatted for dates.

[VBA Noob]

Widen the column

VBA Noob

[terryainsley]

brilliant, so can i copy that all the way down the sheet??

thanks for this

[VBA Noob]

Change range on this line

Please Login or Register  to view this content.

to either

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

VBA Noob

[terryainsley]

Thanks

Works

[VBA Noob]

Glad it helped

VBA Noob