VBA Code to remove Data embedded in the "Pick From Drop Down List"

[Steve Belsch]

Please see the attachment. So, as an example please right click on cell A7 and select from drop down list. Even though the cell appears blank there is a list of values that you can select from. How can I make that go away with a VBA code or otherwise?

Thank you.