I have a excel file with 2 worksheets. The first one is called "Data" and the
second "Define IT Systems-Outsourcings".
Worksheet "Data" contains 3 rows:
- row A titled "Control Description" with 39 entries,
- row B "IT Systems" with 4180 entries, and
- row C "Outsourcings/ Contract ID" with 1052 entries.
In the "Define IT Systems-Outsourcings" worksheet, I have created a group
box with 3 List Boxes:
- The first list box is Single selection type and it is linked to row A of
work sheet "Data".
- The second list box is Multi selection type and it is linked to row B of
work sheet "Data".
- The third list box is Multi selection type and it is linked to row B of
work sheet "Data".
How can I make it happen so that on the Multi selection list boxes (i.e. the
one that contains the names of the IT Systems and the one with the
Outsourcings), when I select more than one option the option to be inserted
in a new cell in column J (next to the list box)? The idea is that the user
will have the ability to select more than one name, and those names to be
copied from the list box to a new cell on the right. Won’t this mean that for
more than one selection a new row should be automatically created for the
next name to be inserted (i.e. loop)?
I know that the answer to this is to create a macro but my knowledge in this
area is rather limited. Please keep answer simple if it involves VBA.
Thanks in advance.
|
Similar Threads
