I wonder if somebody can help me.....

Firstly....I am using Excel 2000 on a Win2000 PC

I have a user form that calls up a combo box to allow a user to make selections from a series of dropdowns (12 in all).

I use ONE range of data and each dropdown box references the SAME range.
It works fine....the user can (say) select box 1, make a selection and do the same for boxes 2-12.

The problem here is that once a user has made a selection from box 1, I do not want that particular choice to be available in the remaining boxes.

As the user goes down through the boxes, the available selections needs to reduce accordingly.

In other (simpler) words the selections need to be exclusive.

For simplicity reasons I only want to have one range to select from as it will be a long list. It will need updating regularly.

I initialise the dropdowns as follows....

Private Sub UserForm_Initialize()
For Each rngcell In Sheets("Data").Range("teamdata")
    ComboBox1.AddItem rngcell.Value
    ComboBox2.AddItem rngcell.Value
    ComboBox3.AddItem rngcell.Value
    ComboBox4.AddItem rngcell.Value
    ComboBox5.AddItem rngcell.Value
    ComboBox6.AddItem rngcell.Value
    ComboBox7.AddItem rngcell.Value
    ComboBox8.AddItem rngcell.Value
    ComboBox9.AddItem rngcell.Value
    ComboBox10.AddItem rngcell.Value
    ComboBox11.AddItem rngcell.Value
    ComboBox12.AddItem rngcell.Value
Next rngcell
End Sub
The combobox values are entered into a worksheet on execution of the macro.

Any ideas folks?

I would be most grateful if if somebody can help.

Many thanks in advance

Paul Hodges