Copy one listbox item to same index position in another listbox

[Foreverlearning]

Hi,

Is it possible to copy a list box value to another list box to the same index position.

Example in list box 1 we have 4 items

Name 1
Name 2
Name 3
Name 4

I would like to copy Name 3 to same position in List box 2

blank
blank
Name 3
blank

Thanks
Lionel

[AlvaroSiza]

Hi Learning,

Consider the following. We'll simply pass the 3rd index position (2 in the code as indexes start at zero) of LB1 to a string, and pass that string into the AddItem of same position in LB2. Hope this helps,

Please Login or Register  to view this content.

[Andy Pope]

Assuming userform with 2 listboxes and a commandbutton.

Add code to userform code module.

Please Login or Register  to view this content.

If you need to insert within the list rather than overwrite existing entry look at the AddItem method and it's optional second argument which specifys the position

[Foreverlearning]

Hi Guys,

Thanks for the responses. Now I know it can work.

The idea I now have is if I click on say item 3 in list box 1 and click the index position on list box 2 it would place the value
of list box 1 in that position.

Can this be achieved?

Thanks
Lionel

[Andy Pope]

Please Login or Register  to view this content.

[Foreverlearning]

Thanks Andy I can build on this.
A variation of your previous post

Lionel