IF Range Value True

[zarahel]

Good afternoon

I´m trying to set a Private Sub Worksheet_Change where everytime the value "ENTRY" is detected on the column C, the correspondent cell on column D is filled with the current date.

I´ve found a code thats more or less what i need:

Please Login or Register  to view this content.

Problem is, that I need to define the value "Entry" somewhere on this code. I need it to fill the current date only when he detects this value.

Any help is appreciated.

Thank you

[zarahel]

Ok, so I found how to do it

But i still have one last problem.

Please Login or Register  to view this content.

Now, I just need to make one last validation. I want it to write the date on target 2 only if the cell is empty. If it has any value it shouldn´t do anything.

Anyone?

[tkowal]

Please Login or Register  to view this content.

[tkowal]

Sorry did not see that it was already answered..

The second part can be accomplished:

Please Login or Register  to view this content.

[Colin Legg]

Since you're using the Change event handler, if you are going to change the value of a cell, you need to temporarily disable events to prevent the procedure from calling itself recursively. Something like this:

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.