Automatic more selections on listbox when changing Workpage

[francisvandergr]

I have a listbox with the values 'A' , 'U' and 'P'. When i change to a Worksheet i want that on that worksheet automatic values 'A' and 'U' are selected.I trie this with the option selection in field of the worksheet properties. One selection works something like :  Status='A'

[#2 · Accepted solution]

Hello Francis,

I would use an "OnactivateSheet"-Trigger.

Look for it under sheet props --> trigger tab --> add an action "select in Field" with fieldname='Status' and searchmask sth. like "(A|U)"

Regards, Roland

[francisvandergr]

Thnx!!