I have a small Data in excel , The problem im facing with Listbuilder and Label Textbox . I have fixed the functionality but now for e.g. i select 1 state = it shows 1 state in the box , when i select all states , it comes all states in the box , but when i select 2 states or 3 states , they are not coming only 1 state is coming at a time when i hit update on listbuilder ( the result comes in label box) . I will really appreciate if u can help me out here .I want the States separated by " ; " Semi colom as well , i think i can figure that out but the most important thing is if i want to select 2 or 3 or 5 states , it shld appear in the text box separated by a semi colomn .
Will Really Appreciate if i get a quick hint or quick reply
The List Builder Destination range needs to be the same number of rows as the Source Labels Range.
You are putting the destination range as One Cell and binding that cell to a label, which is incorrect.
Set up the destination range to be as many rows as the Label range, then create an Excel formula in another separate cell that concantenates the destination cells into one. In that formula you can separate your values by " : " or what ever characters you choose.
Thank you for replying. Yes i have given the range for the Listbuilder as many as rows for source the same for the destination.where im mistaking is the concatenation part , like i said i want to show 2 or 3 states from list builder and it should appear in the label box .Just confused with formula , the destination cells in my excelsheet for listbuilder is from A17:C28 & source is A1:C12. if you can tell me how and where to put the formula and how will the formula start will really help me run these component well.Also if you can provide your email i can provide you a swf for this case or xlf.This is a nice practice for me but im stuck :S
(BOB member since 2008-06-05)
i figured it out … Thanks Both of you !