Date modification

I have a spreadsheet im creating for ordering items. Each time a user puts in an order I want it to be stamped with the date in a cell on the line with the order. I have tried linking cells to the today function but can find no way to automatically convert specific cells to static dates as opposed to functions.
Every time I write a macro or try to look up date help I can never find how to make one action stamped with the date on a row and not change the next time you open the spreadsheet. Any help or any suggestions on where to get help would be much appreciated. THANK YOU... -Jon

Hi Jon

You need event code for this - right-click on the tab name where you want this date to get stamped and choose View Code. Paste the following into the VBE which will open up:

Please Login or Register  to view this content.

Everytime someone amends column A on this worksheet, the corresponding cell in the B column will be stamped with the current date. You can amend these columns as appropriate.

Please post back if you need further help.

Richard

thanks for the help richard, im having a problem changing the target column from A to F...As im sure you can tell Im just starting to try and get hold of this programming stuff. I could def. ask a bunch more questions but I think once I can move from column a to f here I should be fine. Cheers, Jon

hi jon,

not sure but it

is this

Please Login or Register  to view this content.

try this

Please Login or Register  to view this content.

i asume the =1 is column a
=6 is column f

Steve,

That's it...my spreadsheet is functional as of now..Thanks everyone for your help, I think im starting to understand this VBA thing. -JON