Change document name and URL with Listbox and textbox.

[molesy01]

Hi

Userform1
Textbox 1
Textbox 2
Textbox 3
Textbox 4
Listbox 1
Command button (change)
Sheet 1

I have a userform with a listbox and 4 x Textbox.

I need to list items in Listbox 1 from column A & B. A=Document & B = URL. from Sheet 1.

I need to be able to have the list of documents in listbox from sheet 1 cells ("A") this list is not definitive could be 10 or more, same with URL in ("B")

When you chose a document in the listbox i need the current document name to populate in Textbox 1 and URL in Textbox 2.

Textbox 1 = document name in A1
Textbox 2 = URL in B1

Textbox 3 = New document name
Textbox 4 = New URL.

I then need to change the document name in Textbox 1 and URL in Textbox 2. by typing in Textbox 3, and cut and paste new URL in Textbox 4, when i hit the change button i need the new document name and URL to replace the existing cells in Sheet 1.

Hope someone can help.