Date and Time stamp column when row updated

Can you help modify the attached VB code.

whenever a person updates any content in a row I want the date to appear in one column and the time in another - the attached only does a combination - I did manage to did it but deleted it and can not get it working again

So If I put content in A1, ,B1,C1 it should update E1 with the date and F1 with the time

Not sure why you can't just do this, since you have the routines set up:

Please Login or Register  to view this content.

Clearly, you need to adjust the column and row settings or you could overwrite data

Or, you could pass the row and column to one routine and combine the two:

Please Login or Register  to view this content.

Regards

Try this

Please Login or Register  to view this content.

royUK - thanks - I have edited it for each sheet - I think the original coding was a little different but this works.

TM - that codes still just shows (Now) with a date and time in the same box

Thanks

Must admit, I just combined the code and didn't try it out.

Never mind, you have a solution.

Regards

Please Login or Register  to view this content.

The date being produced buy the code Gives a data MM/DD/YY, but my system is set to DD/MM/YY - why? and how do I fix this?[/

Fixed it - just in case you need to know - you have to use dd/mmm/yy for this to work - found the answer. In VB it will always default to american