so, do you mean you pick a cell (A1) in Excell, the code gets the information of the part in cell B1, and fill A1 with the info? if yes, this is pure a question of Excel. Or I am misunderstanding?
On my click to run rule i got from iLogic to choose one of many available codes. On Ok it guide me to available materials and i choose my material.Code is alfa numeric and it is in column A in Excel, and material is just text description in Column B. Every row got own code and description. So now when i click Ok iLogic is giving me message The code is ..,and one more time Ckick Ok and i got msg The description is....That is working like i said last time just fine. No errors .But what if i click on desired code to get code in iproperties for code and description for that code to be filled without extra looking for material on very huge list. So with one shot to kill two flies.
Well, if I understand correctly, you have a list of code and a list of description. Each code corresponds to each description. They are in the same row of Excel. You firstly get the list of code, input them in the InputListBox (let us say ListBox1), next get the list of description, input them in another InputListBox (let us say ListBox2)
Now, you select one item of the ListBox1, next, you have to find the corresponding description in ListBox2. While the list of material is large, it is not easy to find the correct item.
If this is your problem, I would suggest you add a numeric prefix for each item in the two ListBox2. The number is the row sequence e.g.
01 – description1
02 – description2
03 – description3
By this mean, if the user selects an item in ListBox1, he can locate the item in ListBox2 easier.