Default setting in ListBox with Trigger

[Anonymous]

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

[jonathandienst]

And your question is?

[Anonymous]

How does a Trigger works, how is the formula?

[jonathandienst]

The "Select in Field" formula would be (AD|AS)

On exit, use a "Clear Field " action

[Anonymous]

Trigger ist not working?

[Qrishna · Accepted solution]

Check out the attached qvw.

result:

[Anonymous]

Now, Trigger is working fine.

character  =  was missing

Solution:

(Action) Select in Field

(Field) Site2

(Search String) ='(AD|AS)'