Delete a drop down box

G

Gord Dibben

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
 
C

challa prabhu

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
 
Top