Thanks Dave. As always you have been a big help. I used the forms toobar to
create the button and the combo drop down box. I'll try to use your code.
--
Gary Baker


"Dave Peterson" wrote:

It would depend on what you used to create that dropdown--and where you'd place
that code would depend on the type of button you used.

If you used Data|validation, then...
worksheets("sheet1").range("a1").clearcontents
or
worksheets("sheet1").range("a1").value = ""

If you used a dropdown from the Forms toolbar, then...
Worksheets("sheet1").DropDowns("drop down 1").Value = 0
or
Worksheets("sheet1").DropDowns("drop down 1").ListIndex = 0

If you used a combobox from the control toolbox toolbar, then...
Worksheets("sheet1").ComboBox1.Value = ""
or
Worksheets("sheet1").ComboBox1.ListIndex = -1


GWB Direct wrote:

I have a drop down box with the first cell in the list I left blank. I woulod
like to set up a button that would reset the drop down button to a blank.
What would the code be.
Thank You
--
Gary Baker

--

Dave Peterson