Validating drop down

After you select a Region, the drop down list in column C shows the customers in the selected region.

Go back and select a different region, and the existing customer name will be cleared. Clear Contents End If End If exit Handler: Application.

Any unauthorized use, sharing, reproduction or distribution of these materials by any means, electronic, mechanical, or otherwise is strictly prohibited.

Limit the choices in an Excel drop down list, depending on the value in another cell.

Normally, when you create a drop down list in a worksheet, the drop down list will not be changed with the new data entering dynamically, in this case, you need to modify the source data to extend the list manually.