Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

RK1977
RK1977
Offline

Badges

Badges
3

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
5

Discussions

Discussions
0

Questions

Questions
5

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by RK1977
Customize the badges you want to showcase on your profile
Re: Copy and paste 500 items from Excel into Listbox - Adobe LiveCycle 27-05-2010
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 ...

Views

170

Likes

0

Replies

0