Enter the ListBox data to another sheet

[Pyro Form]

Hi, I require assistance. I have a Userform1 with 2 listboxes. ListBox1 shows the name range A4:A200 from Sheets("Test"). I select certain names from this list using the Add button which transfers to ListBox2. I need to then enter this into the same sheet but in column B and the names need to be the same as in Column A. (i.e - B14 needs to equal A14)

[Leith Ross]

Hello Pyro Form ,

It will be easier to code a working solution using the workbook.

To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Pyro Form]

Leith,

Thanks for your reply. I have been working on a Resource Management System in my spare time over the 2 months. If you don,t mind, I would like to send this to you for comment. This is not the same one as discussed previously but due to my inexperience I was planning on developing a revised version. Is 12mb too much to attach?

[Leith Ross]

Hello Pyro Form,

Try zipping the file to reduce it's size. If it is still too large you then can email a copy to me at LeithRoss...gmail.com. Replace the ellipsis (...) with the at sign (@).

[Pyro Form]

Leith,

I have sent the file to your gmail. Please let me know if you receive it. Thanks in advance.

Regards,
Pyro Form (Tony)

[Leith Ross]

Hello Tony,

There seems to have been a probable with the file. All I received was a message saying the original file was unscanable.