Open the control toolbox and add a command button to your worksheet.
Then right-click your sheet tab, hit View Code and add this:

Private Sub CommandButton1_Click()
Cells.ClearContents
End Sub

--
Dan

On Dec 31, 11:05*am, wrote:
Hi,

* *I'm not very knowledgeable on codes and all that intails. *What I'm
trying to do with Microsoft Excel is create a spreadsheet using data
validation. *I've gotten that part complete. *Now what i'm trying to
do is add a "Clear" button so that the drop down data validation cells/
menus will remain intact but the clear button will turn the cells
blank so that the input user will be able to start over with the drop
down menus. *Hope this makes sense. *Thanks for any help.