Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! how do I automatic unslect 3items by using wildmatch function (NON*) in a list box? I tried going to sheet properties and added action select excluded..It works but when i clear all my selections , the select excluded doesnt function anymore. I was thinking of doing the action select in field but just don't know to compose the formula for wildmatch.
Tks.
You need 2 actions. First you need to do a Select in Field of the values that you DON'T want. Then you need a Select Excluded below that first action.
Regards,
Vlad
Vlad,
The excluded items were grayed out but the values I expectected is wrong.
Tks.
Please post (1) the field name and (2) the values you are selecting in the Select in Field action.
Vlad