How do you Reset a Combo Box

P

PJ

Hi

I have a few No/Yes Drop down option in Excel

They all default to No unless user changes it to Yes.

What I am after is a reset button to change it back to No

Thanks

Paul
 
G

glenton (glenton

Hi PJ

For Yes/No questions might you not be better off using a checkbox?

To answer you question it really depends how you've implemented your
combobox. I'm guessing that you've done it using either validation or forms.

Validation:
Easiest is to make a macros that changes the values to No. e.g.
Sub MyReset
sheets("yoursheetname").range("d5") = "No"
sheets("yoursheetname").range("e7") = "No"
sheets("yoursheetname").range("b11") = "No"
End Sub

(You open the visual basic editor and save this in a module. You might have
to create a new module)

Then back in excel, right click the tools bar, make sure that forms menu is
ticked. Then click on the "button" button and create a button on your sheet.
Assign in the MyReset macro. You could also use a drawing object and assign
a macro to it.

Actually this would work pretty well if you were using forms too.

Let us know if this doesn't sort you out!

Glenton
www.leviqqio.com
 
Top