Worksheet change for 2 functions

Hello,

I am trying to have a worksheet_change function that

a) Enter the date a cell was last changed into a specific row and columns

which I got working.

now I want to add

b) a function that if a certain cell has the word YES in it, the message box to add a link to a document should open.

I have something working on excel 2016 but it gives a not sufficient memory error when running on excel 2010. When I unmark the lines below I get the error on excel 2010. I don't have an excel 2010 on this machine but would like to get rid of this error somehow.

can anyone help me out?

Please Login or Register  to view this content.

Thank you so much

Hi

i have attached the file.

Seems to be with changing cells that already existed now. Cant really figure out how to address this.


Thank you for looking at it.

I am not seeing a problem with how this code runs, testing on Excel 2013.

When i remove text from a cell, or change it , it also doesnt update the date anymore.

I don't understand what you think the problem is. When you make a change, the macro sets the date in column L to today's date. If you make another change, it still sets it to today's date but of course, it still looks the same.

What do you see happening, and what do you want to happen?

Originally Posted by 6StringJazzer

What do you see happening, and what do you want to happen?

It works pretty well, I have only noticed that it stops adding the date once i deleted the content of a cell.

For example when i add content to an empty cell, it will put the date in Column L. If I then delete the content lets say of F6, and go on to write in another empty cell (F20), the date does not appear in column L row 20. I have to then press Update Button, and after that it would be working again until i deleted the content of a non-empty cell.

Everything else is working fine. Thank your for that little, but very helpful pointer!