User Form List Boxes and Adding and Deleting Data

Hello,

I appreciate any help that can be provided.

I have a userform called uf_Modify and a listbox in it called lb_Delete. The data in the listbox is being populated from a particular range called "CompanyList" in one of my worksheets. I am trying to set it up so the user can delete unwanted companies that are listed in lb_Delete and then update those changes on the worksheet within the range "CompanyList". I also want to give the user an option to add more companies via the User Form that will update the range "CompanyList" and also reflect the updates in a second userform that will be called that will have a listbox that shows all the changes that have been made to the range "CompanyList". I would really appreciate any help that can be provided.

Regards,

William

Hello William,

You should post your workbook. It is unlikely anyone will take the time to reproduce for themselves what you have already done. It will be easier to make corrections to the existing formats and code than create it from scratch. Also, it makes question and answers much easier since the workbook can be referenced by everyone involved.

Hello learning_vba,

Thanks for posting the workbook. My guess about the layout was way off! That's why the workbook really helps.

Note: This workbook sets up a web query to finance.yahoo.com