clearing a drop down menu entry

P

possum b

Is there a way to clear entries made by a drop down list?
I would like to clear 5 cell entries when the sheet is opened and by
selecting the master cell in worksheet.
 
D

Don Guillett

A better explanation or
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
G

Gord Dibben

Sheet is activated or workbook is opened?

Which 5 cells would you like cleared?

What is the "master cell"?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formatting in Drop Down Lists 2
Size of drop down in validation list 2
Drop down list and macros? 1
Recording new Macro won't reset drop downs 3
Create Drop Down Box populated by a List 1
Copying a Drop Down Menu 2
Filter a Drop List ? 1
Drop down List w/ Values Pop Automacailly when choose entry from l 8

Top