Button creation to reset values from drop down lists

Hello there, I am new to this forum and was hoping someone could shed some light on the slight confusing situation I currently find myself in.

I have been tasked with creating an easy to use pricing system for an upcoming show allowing quick and accurate quotations for customers. I have created several drop down menus to correspond with the many options available. What I would like to do, if its possible, is to create a button in the spreadsheet that will reset the information within my drop down lists to the "No Selection Made" choice thus resetting all costs.

Is this possible? If so, how would I go about making this a reality?

Thanks in advance.

Try:

Sub VBA_Clear_Contents_Range()
Range("A2:D10").ClearContents
End Sub

Hi Lewis, will that clear all contents within the sheet? By this I refer t formulas currently in place.

The formulas are getting results from cells. Set the range to clear the data not the formulas.

Agreed, clear data not formulas, exactly what I was wanting to do. I have set the range according to my sheet however am at a loss as to how to get it to work by means of a button.

Insert a shape and assign the macro to it.

I tried that however macros have been disabled, guess I should have led with that. Cant use ActiveX either as most of the people using the sheet are on apple based products.

save the file as macro enabled xlsm

Ok so I got that to work, it clears the contents completely, however instead of clearing completely can I get it to enter an option instead, for example "No Selection Made"

You can use highlight cell rules for that. I like to do this way for example. Make the cells red until data is in there. That forces the user to enter something.

The soon to be users want something a little more corporate than that.

Is there a command I can add to the existing macro that will enter a preferred word into the cleared cell space?

Yes use a formula in the highlight cell rules. You have flexibility there.

Maybe someone here has spare time