One option to do this is:Add a formula into your excel sheet into an
empty column.. and then copy all the rows to Initialize event of the
ListBox. Change the A85 and B85 according to your data. A85 in the below
formula represents Display text for List Item and B85 represents Value
for that list item.
=CONCATENATE("this.addItem('",A85,"','",B85,"');")After you add the
formula, you get a text similar to this.
this.addItem('Ireland','IE');Just copy all the 500 rows and then place
in the Initialize ...