How do I have excel add an drop down list if the cell before it is populated with text?

Originally Posted by Keebellah

The posted code does just that.

I meant to say how do I have it delete the text in D13 when unchecked, I figured it out