Combobox with Data Validation so that same value cannot be selected

**brillison** · 11-11-2009, 01:00 PM

Hello

I have 5 combo boxes in a userform. Each combobox has the same values in the drop down (numbers 1,2,3,4,5,6,7,8). I need to do a data validation such that if the user selects "1" in cboInvestmentList1, then the user cannot select "1" from cboInvestmentList2 through cboInvestmentList5.

Additionally, I would like an error message to pop up explaning that the value cannot be selected more than once.

If I were using the excel data validation my equation would look similar to:

cboInvestmentList1: =cboInvestmentList1<>cboInvestmentList2:cboInvestmentList5

cboInvestmentList2: =cboInvestmentList2<>cboInvestmentList1,cboInvestmentList3:cboInvestmentList5

cboInvestmentList3: =cboInvestmentList3<>cboInvestmentList1:cboInvestmentList2,cboInvestmentList4:cboInvestmentList5

cboInvestmentList4: =cboInvestmentList4<>cboInvestmentList1:cboInvestmentList3,cboInvestmentList5

cboInvestmentList5: =cboInvestmentList5<>cboInvestmentList1:cboInvestmentList4

Any help would be appreciated!

**JBeaucaire** · 11-11-2009, 01:31 PM

Here's a technique I use for self-diminishing drop down lists to make duplicate choices impossible. Perhaps you can adapt this for your use in the combo boxes.