Two Validation options possible?

[pbeumer2001]

Hello,

first of all sorry for my bad englisch. I`m dutch. I`m creating a timetable for my colleague at work. Now I wanted to give some cells a list. In this example for the numbers 1 till 10. But wenn a number is used it has to disappair from the list. What I really want is that it is even impossible to enter. What I want are 2 validation options but I looks to me I only can set one option at the time. I included a example I made. Here my option list decreases every time I use a number but I still can use a number I allready used. If I`m not clear enough let me know.

Example.xlsx

Greetz Patrick

[Winon]

Post deleted. OP has complied with request to change thread title.

[mrice]

Try adding the following to the Sheet1 tab in the VBA editor (alf F11)

Please Login or Register  to view this content.

Also set the validation in B2 to be the simple list 1,2,3,4,5,6,7,8,9

As you add numbers to column B, the validation should adapt.

[Winon]

Post deleted.

[pbeumer2001]

Yes,

This works like a sharm thank you!!!