Move data between ListBoxes
 

I created a UserForm with two list boxes (ListBox1 & ListBox2). Right now
when I show the Form ListBox1 is the only ListBox with choices inside of it.

The problem I am having is that Id like to be to be able to double click a
selection from ListBox1 and have it be moved over to ListBox2. Similarly, I
would like to be able to double click a selection after I have moved it to
ListBox2 and have it be move back over to ListBox1. Can you help me develop
the code that will perform the procedure I am trying to add to this form?

Move data between ListBoxes
 

see if this helps

http://www.dailydoseofexcel.com/arch...een-listboxes/
--
jb


"Rock" wrote:

I created a UserForm with two list boxes (ListBox1 & ListBox2). Right now
when I show the Form ListBox1 is the only ListBox with choices inside of it.

The problem I am having is that Id like to be to be able to double click a
selection from ListBox1 and have it be moved over to ListBox2. Similarly, I
would like to be able to double click a selection after I have moved it to
ListBox2 and have it be move back over to ListBox1. Can you help me develop
the code that will perform the procedure I am trying to add to this form?

Move data between ListBoxes
 

This is useful. Thank you.

"john" wrote:

see if this helps

http://www.dailydoseofexcel.com/arch...een-listboxes/
--
jb


"Rock" wrote:

I created a UserForm with two list boxes (ListBox1 & ListBox2). Right now
when I show the Form ListBox1 is the only ListBox with choices inside of it.

The problem I am having is that Id like to be to be able to double click a
selection from ListBox1 and have it be moved over to ListBox2. Similarly, I
would like to be able to double click a selection after I have moved it to
ListBox2 and have it be move back over to ListBox1. Can you help me develop
the code that will perform the procedure I am trying to add to this form?