Code stops working

Hi,

I have some code that produces a name in one cell when a number is put in another cell, this works great. (i got the code from here https://www.excelforum.com/excel-pro...signature.html)

I am now trying to put the date in an adjacent cell when the name appears using =IF(C1="Name",Today(),"")
When I do this the code stops working

I know very little (nothing) about code so any help appreciated!

Thanks

Kevin

Kaper,

Thank you for your response, I have attached a sample file, the code is a little different then above as i am trying to learn VBA and have been playing with it.
I would like to do it all in code, but I am still very curious as to why it wouldn't work with a fourmal?

Thanks for looking

Kevin

Hi Kaper,

Many thanks works great. how would add If name is deleted then delete timestamp?

Thank you

Kevin