Removing an option from a drop down menu after it is used.

I have some randomly generated numbers that I figured out how to lock, From that list I created a drop down menu that lets me pick one of the randomly generated numbers. I use this same drop down multiple times.

Here is my issue.

I am making this document for random people's use so it needs to as user friendly as possible and I need the number selected in each of the drop downs to not be a duplicate of a number already used. To complicate the process the numbers can be the same number if it was generated randomly to be the same number.


Simple example

10 random generated number between 1 and 10 will be my drop down menu.

7, 3, 2, 4, 5, 7, 9, 10, 1, 3

I have 5 drop down select option. So in option 1 you can place any number you like.... Lets use 10 for this example. I want the next drop down menu to then have all the options up there except for 10. So for the second drop down you pick 7(which there are 2 7 options). After selecting 7 in the third option there would still be a 7 option but only 1.




I hope that explains what I am trying to do... not sure if its possible but it will making explaining the process much more simple for me.

There is probably a more elegant way, but this works, it goes in a standard module and the macro should be assigned to the dropdown

Please Login or Register  to view this content.

There is probably a more elegant way, but this works, it goes in a standard module and the macro should be assigned to the dropdown

Please Login or Register  to view this content.