1

Topic: To take values from the list

Good afternoon!
Found in a network such example. In the field (2) request from the table. In the field we select the necessary data and it is deduced in the report.
In VBA it looks as "Spisok2.ItemData" and the code from the table is pulled out. How to make so that values (in this case the company) and  through a comma would be pulled out immediately.
I.e. short question such: From a field where it is possible to select some values how selected to take and enumerate through a comma?

2

Re: To take values from the list

ItemData is a value of the bound column. To receive value of any column, apply cd-dj Column (n). For example, for the second column: 2.Column (1)
For obtaining of all selected values in the list with a multichoice - a cycle on ItemSelected

3

Re: To take values from the list

(Kiev) wrote:

ItemData is a value of the bound column. To receive value of any column, apply cd-dj Column (n). For example, for the second column: 2.Column (1)
For obtaining of all selected values in the list with a multichoice - a cycle on ItemSelected

If I put.column (1) - that is added always only the first selected.
And it is necessary to receive really all selected values in the list through . (For the further input in request)

4

Re: To take values from the list

Can  it is useful:

5

Re: To take values from the list

ExcVl wrote:

.... If I put.column (1) - that is added always only the first selected.

And it is necessary .column (1,3) or.column (1, i) - pay attention to helps

6

Re: To take values from the list

sdku;
Fine! Thanks huge that is necessary.