Here is my problem. I have a listbox with values A, B,C, D,E, F, G, H, I, J, K, etc. I want to use the 'Select Exclude' feature from a listbox. Meaning, when you right click on a value in a listbox and select 'Select Excluded' it displays all data excluding that value. This works perfect. However, when I display only certain values in a listbox say C, J, W. and the user select value 'C' and then hit 'Select Excluded', the data that only displays is for 'J' and 'W' excluding 'C'. But the data I want to display is ALL values (A, B, D,E,F,G,H,I, J, K,etc EXCLUDING 'C') . How can I get this to work?
You are filtering the values in the list box somehow, maybe with an if() statement? I think any selection command that you envoke on this restricted set will only be applied in the scope of your restriction, i.e. to the values set C, J, W in your sample.
Could you explain a bit more what the use case is? Maybe there is a different solution to what you want to achieve.