In Document Event Triggers, OnOpen-->Select on Field selection
I have a hard time finding a solution to the following challenge:
I have a list box called "Buyers' and has 100 values, and I have another field called "Favorite Buyer"(from different source) has 5 values.
When I open the page it will display only the "Favorite Buyer" values in "Buyers" list box as default. later if I want to clear the default values then "Buyers" list box will display all the 100 values.
I have set the trigger like:
Sheet Properties==>Triggers==>OnActiveSheet==>Select in Field==> Field is "Buyers" and Search String is "=[Favorite Buyer]"
Re: In Document Event Triggers, OnOpen-->Select on Field selection
I haven't had the best luck using On Open > Select in Field triggers. A workaround that I usually resort to is entering a search string into the listbox (using the search function), then saving the result as a bookmark. Create an On Open > Apply Bookmark trigger and see it works for you.