clearing a combobox

[Ryan]

I have an Excel spreadsheet with several comboboxes on one sheet. I need to
add a button that will reset all the boxes to their default value. Does
anyone have a macro to do this?

 

[Rick Rothstein]

Default value? Do you mean with nothing in them? Or some other default condition?

Also, since these ComboBoxes are on the worksheet, which toolbar did you get them from... the Forms toolbar or the Control Toolbox toolbar?

 

[Ryan]

The default condition should be an asterisk. I got the ComboBoxes from the
Control Toolbox toolbar.

Thanks.

 

[Ryan]

The default value should be an asterisk. I created the Boxes using the
Control Toolbar.

Thanks.