Auto date A1 when typing in A2

**seanjacob** · 08-16-2010, 08:07 AM

I would like to automatically put the date in cell A1 when I type in A2. But I don't want to use =now() becuase it auto updates. You can get the date by pressing crtl and semicolon without updating itself but I can't figue out how to put this in a formula.

=IF(A2<>"",NOW(),"") but instead I want to use crtl + ;

Thanks.

**sweep** · 08-16-2010, 08:18 AM

Hi,

Place this code in the worksheet module

Please Login or Register  to view this content.

To do this,

right click the tab of the appropriate sheet, select view code

paste the code into the VBA editor that pops up

close the vba editor.

**seanjacob** · 08-16-2010, 08:27 AM

Thanks for the reply!

Sorry I didn't explain myself well. I would like this to run down the whole column so if typed into cell b6, a6 would show the date.

Also using now() makes the date auto update which I would like it not to do.

**sweep** · 08-16-2010, 08:38 AM

Now modified to timestamp column A next to an entry in column B.

Please Login or Register  to view this content.

Does this work for you?

**seanjacob** · 08-16-2010, 09:20 AM

Yes that worked great thankyou. Do you recon their is not a simple formula way of doing this? The only problem is that now() updates itself if only i could swap now() with crtl+; .

**seanjacob** · 08-16-2010, 09:22 AM

How do you solve a thread?

**sweep** · 08-16-2010, 09:29 AM

I don't know of any way to do what you want without code, sorry!

To mark your thread solved do the following: - Go to the first post - Click edit - Click Advance - Just below the word "Title:" you will see a dropdown with the word No prefix. - Change to Solve - Click Save