Populating List box with data from other excel file

[johnske]

Hello John,

The listbookdata.xls, which contains the data for populating the listbox is available to users on a network; I am wondering, if the invisible filesharing might create some problems.

Also, after populating the listbox, (I changed the multiselect property of the listbox to fmMultiSelectExtended), the insert command is not copying the multiple selection that I made in the list box. Can you please check.

thanks
prakash

Hi prakash,

1) What sort of problems do you mean?

2) The example given of how you wanted your output had the entire (separate) list of each "class" or "item" (wall, floor, roof) in the A to D columns of the ListBook. So that's exactly how I set it up - to simply copy ALL the walls, or ALL the floors, or ALL the roofs into those columns with the "Insert Selection" button you had.

To do what you appear to want to do now would require something different altogether as we would then be looking not only at classes, but at sub-classes as well - do you mean: a) multi-select before or after using the option button and then b) use your Insert Selection button, or to c) use a Double-Click event to insert the multi-selection?

John