Select Multiple Items in Listbox on Sheet Activation

[akile002]

I have a listbox with multiple numbers. When the sheet is activated, I want the numbers 41 and 44 selected. Is it possible to do this?

[Gysbert_Wassenaar · Accepted solution]

Yes, you can use the OnActivateSheet sheet trigger to execute a Select in Field action. Open the sheet properties window and select the Triggers tab. Click on the Add Action(s)... button under OnActivateSheet. Click on the Add button to add an action. Choose Select in Field and click on OK. Next enter the field name of the field you want to select the numbers in. Enter as search string (41|44). Click on OK and again OK to add the action to the trigger.

[akile002]

Thank you. This worked perfectly.

[#4]

How do I do when the listbox values are text ?

I have tried the pipe but I only get first value selected upon activation of the sheet

[israrkhan]

Hi Fredrik,

in case of text box try like below:

in search string. let say you have these three values.

='(Fulfilled | "Partially Fulfilled" | Closed)'

you saw the " " around Partially Fulfilled value, because it has space, its is one value "Partially Fulfilled"

hope it helps..

[#6]

Thanks it works now

[dmohanty]

Hello @Gysbert_Wassenaar  - hope you are doing good.

How to get the regular display in Current Selection Box like 41, 44 instead of (41|44), even though we click thru button ?