How do I detee a drop down box once it has been created

If it is a dropdown from Data Validation>List just click on it and Data
Validation>Clear All.

If a dropdown from the Control Toolbox go into Design Mode and delete it.

If from the Forms Toolbar just right-click and delete it.


Gord Dibben MS Excel MVP


On Tue, 21 Aug 2007 11:48:02 -0700, Nancy <(E-Mail Removed)>
wrote:

>How do I detee a drop down box once it has been created

Hi,

Do the following:

1. Select the range with the dropdown list in the worksheet.
2. On the Data menu, click Validation.
3. Under validation Criteria, click "Any Value" from the "Allow" list.
Note: If the "Allow" list displays "List" and your Source" text box displays
the selected range, then change the selection in the Allow list to "Any Value"
4. Click Ok.

Challa Prabhu

"Nancy" wrote:

> How do I detee a drop down box once it has been created