Multiple selection in single list box using tigress

[#1]

Hi All,

i am looking for below requirement solutions can anyone help me with solutions.

I have Inline table like Product

ProductID, ProductName

1, Computers

2, Mobiles

3, Laptops

4, Large Acc

5, ACs

and i have another table comes from Excel:

Products Table:

Product_ID

2,

3,

5

When ever excel can reload defaulting excel sheet-> Product id's has to select in my listbox...

Can anyone help me asap.

Please note using macro i need it.

Thanks,

Surya.

[Kushal_Chawda]

try to apply trigger onOpen, or on Active sheet which you have applied on button

[#3]

This need to do in Macro

[ankit777]

Hi

Create a variable like

var=concat(excel_productid,'|')

then create an action on post reload

select in field - Product_ProductID

value- ='('&var&')'

This will select all product value in excel in the products table every time you reload.