Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I will use Sheet Properties to set a default setting. With Sheet Event Triggers 2 Values on ListBox (“AD“ und “AS“) should be selected. If I leave this sheet Trigger “OnLeaveSheet” setting in ListBox should be clear.
Regards
Stefan
And your question is?
How does a Trigger works, how is the formula?
The "Select in Field" formula would be (AD|AS)
On exit, use a "Clear Field " action
Trigger ist not working?
Check out the attached qvw.
result:
Now, Trigger is working fine.
character = was missing
Solution:
(Action) Select in Field
(Field) Site2
(Search String) ='(AD|AS)'