Clear cells

[Dave]

Excel 2003

I have a column of cells that are all drop down lists.

I want a button that clears all selected values in that range of cells.

How can I do that?

Thanks

Dave

 

[Dave]

OK - I guess I can do it with a macro but how do I make a nice button?

Dave

 

[Dave]

Thanks, I will try that. I first tried just using a text box with some
shadows. Works but a "real" button would be better.

Dave

 

[Gord Dibben]

You don't need a macro.

Select the range and right-click>clear contents.

But record while doing it to get the code if you really want the macro.

You can assign a macro to just about any object..............your
interpretation of "nice" may not be same as mine.

Button from the Forms Toolbar, Wordart object, photo of yourself.

Or place a button on a Toolbar.

Tools>Customize>Commands.

Scroll down to Macro and drag the smiley face to a toolbar.

You can change that to a face of your choice from right-click>change button
image.


Gord Dibben MS Excel MVP