Button to Clear contents from drop down select in Excel

[Excelsloth]

I cannot seem to find or create the necessary Macro for my clear All button in excel.
I have a yes / no / N/A option in each line of my colum and need to clear the contents without deleting the drop down.
This way the person can reselect 1 of 3 options.

 

[6StringJazzer]

When you say clear the contents, do you want it to be blank? The natural choice for clearing contents would be

Range("A2:A99").ClearContents

Modify to reference where you actually have your data.

 

[Excelsloth]

I cannot seem to find or create the necessary Macro for my clear All button in excel.
I have a yes / no / N/A option in each line of my colum and need to clear the contents without deleting the drop down.
This way the person can reselect 1 of 3 options.

When you say clear the contents, do you want it to be blank? The natural choice for clearing contents would be

Range("A2:A99").ClearContents

Modify to reference where you actually have your data.

Thanks for your advise.
Yes I would like for it to be blank, remove all drop selections. So the person can start fresh.
However I tried use the code you provided and it would not work.
I had tried with my ranges. Range(C3:C6).ClearContents and unfortunately it did not work. Got an error message that my macros were possibly disactivated.
I will have to try and figure something out.

 

[6StringJazzer]

Do you have other macros that work in the same file?

The problem is in your macro settings, not the code. Check your security settings.