Private sub to delete a cell's contents if another cell's value changes to anything but 4

[Josiah]

Cell C5 uses DATA VALIDATION to select from a list.

Cell AO5 uses vlookup to come up with a number based on the selection in cell C5 (so if the user selects the first item in the list in cell C5 then the result in AO5 is 1...if the user selects the 4th item in the list the result in AO5 is 4)

If a user selects ANYTHING but number 4 in the list in cell C5, I want the data in cell H5 to be cleared.

There is already a private sub running on this sheet and I need to add to it. Here's what the existing looks like:

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.

[Josiah]

Thanks stnk

I tried something similar but it wasn't working. I then realized that the document itself was glitching and that nothing was working. Had to restart the program.

Doh