Transfer Item From Range1 to Range2 Using ListBox

**hifliers** · 05-18-2009, 03:40 AM

Dear All,

I Have A 2 Range Named Range1 & Range2 and 2ListBox Named ListBox1 & ListBox2 in Userform1.

Please Login or Register  to view this content.

Now I Want to transfer items from Range1 to Range2 or viceversa usiing ListBox. Please help me to codify this.

Example file will be a better soultion.

Regards,
Vishnu

**MickG** · 05-18-2009, 09:45 AM

Hi, As it is not clear where "Range1" and "Range2" are I have Based this on the Ranges in Columns "A" & "B". When you have got it working change the related Addresses to suit your ranges.
If you Show the Userform In "Edit Mode" then Double click on the Userform. You Can paste the entire Codes Below into that Module.
When you select an Item in Either ListBox, it will be deleted from its related range and Listbox and insert in the Other Range and ListBox.

Please Login or Register  to view this content.

Regards Mick

**hifliers** · 05-22-2009, 02:29 AM

Dear Mickg,

Thanks fo it! It's working me. If I want to use for Multi Column List Box then How to use it.

Regards,

Vishnu

**hifliers** · 05-22-2009, 03:51 AM

Again Some Problems.

How to use column headings? And I am not able to transfer all items from Range1 to Range2. At least 2 item should be there in both the ranges to run the code. Please resolve this issue.

Regards,

Vishnu

**royUK** · 05-22-2009, 04:29 AM

hifliers please wrap all code with code tags.

**Andy Pope** · 05-22-2009, 06:13 AM

Here is a bunch of code on moving items around and between listboxes,
http://www.andypope.info/vba/listboxmover.htm

It will not work if the listboxes are populated using rowsource.

Listbox heading only appear when using rowsource. The row immediately above the defined range will be used for heading labels.