Delete a drop down box

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top