How do I keep the date entry TODAY() frozen on that specific date.

**chartkamp** · 03-06-2014, 06:03 AM

Hi all,

I am working on a spreadsheet to create a school 'tracking' system based on excel. What I need is that as soon as a box in column B is ticked, a date (TODAY() is entered in column A. That is not so difficult, and I have used the formula in cells in column A:
=IF(ISBLANK(Bx);"";TODAY()), where x is the specific row.
So, keep cell A clear untill something is written in cell B.
This works fine.

But, for the purpose I need to keep the TODAY() date fixed after entry. And it need to be erased again if the tickbox in cell B is emptied again. It need then to re-enter a new date after cell B is re-used.

I have looked into your Forum for answers but cannot find it. I know this has to be done with a Macro or VBA, but I am not enough skilled to find out myself.

**Olly** · 03-06-2014, 06:07 AM

Try this in the worksheet module:

Please Login or Register  to view this content.

**chartkamp** · 03-06-2014, 06:32 AM

Thanks! No error messages yet.. I have to wait till tomorrow to see if it works. But it seems a good script!

**chartkamp** · 03-07-2014, 03:34 AM

Hi

I opened the spreadsheet today and the date was changed to 7-03, it updated the date. So something is not working well....

What do I have to do in the spreadsheet? Leave column A empty? Or do I need to link to this module? how to do that?

Can someone look into the problem?

Greetings Christel