Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
After selecting the item to exclude, the user can right-click and Select Excluded.
Thx Micheal.
But this solution is too heavy for the user ,especially that this filter will be used only for exlusion .
any help plz.
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
Thx Mohammed but i didn't get your idea !
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
i think using a trigger is more simple .
THX Mohammed