Exclude values selected in a list box from the sheets objects

[mohamed_ahid]

hi all ,

i'm trying to perform a list box in which the value selected will be excluded from all the sheets (all the application) .

One solution is to do that with set analysis i think (apply this on all the objects of the application) .

the seconde one is to use a trigger wich reverse the selection every time i (make choice) activate  the liste box

is there another solution to do that ?

thx

[m_woolf]

After selecting the item to exclude, the user can right-click and Select Excluded.

[mohamed_ahid]

Thx Micheal.

But this solution is too heavy for the user ,especially that this filter will be used only for exlusion .

any help plz.

[ashfaq_haseeb]

Hi,

One of the work around.

In first i/p box select id  you want to exclude.

Then In Second i/p box enter any number to select excluded value.

Regards

ASHFAQ

[mohamed_ahid]

Thx Mohammed but i didn't get your idea !

[ashfaq_haseeb]

Hi,

Let say that you want to exclude 10 20 30 from CustomerID list box

Download the attach file 

In first i/p box type 10 20 30 --> Then hit enter, It will select values 10 20 30 from CustomerID list box.

Second step type any number in second i/p box --> type any number let say 50 hit enter.

Now it will exclude your previous selection. i.e from  CustomerID list box everything is selected except 10 20 30.

Hope it helps

Regards

ASHFAQ

[mohamed_ahid]

i think using a trigger is more simple .

THX Mohammed