How to search multiple values at a time from list box ?

[geam1988]

Hallo,  I have a list box of multiple value, i want to copy multiple sales order number from excel file and paste in search option in List box.  not interested to use CTRL and select value one by one. i want to select multiple value from list box at a time.

How to do that ?

Best regards, Kazi

[sunny_talwar]

Look at this thread by @swuehl

Compound Search - demystified

[marcus_sommer]

You need to create a single search-string from your values. For this you could use a variable within an inputbox which triggers a selection-action on your field with a search-string like: = '(' & replace('$(YourVariable)', '  ', '|') & ')' or you creates this search-string directly in excel, like in this example:

This copy & paste approach needs just a few seconds and the last value is then pasted into the listbox-search between the needed wrapping brackets, like:

(CTRL + V)

- Marcus