Clear cells

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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
 
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
 
Back
Top