Look at this link as it will do what you are wanting.
Remove selected options from dropdown list
Look at this link as it will do what you are wanting.
Remove selected options from dropdown list
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
Bookmarks