How to search multiple values at a time from list box ?
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.
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: