Userform vlookup with the ability to save or select values

I've done a couple of things for you in the attached file. You didn't need to use VLookup. The combo box will value the Listindex attribute set to the one selected, so all you have to do be move column 2 of the combo to the list box. Also, I don't think you need to have a button to let the contents of list box be changed. If you just change it and then click "Copy to Sheet" the revised value will be copied.
form_help.xls
Let me know how you're doing.

Thank you very much for the quick reply. That is almost exactly what I want but is it possible for the amended value in TextBox1 to be saved with a click of a button i.e. the cell value to be actually changed?

Thanks that works exactly how I wanted it except that the Copy To Sheet button doesn't work.

I basically need the user to be able to select an option from the drop down list, edit it if need be and either save it for later use or copy it to cell B16 for example.

Also when I add several paragraphs in the drop down the text doesn't wrap is this possible?

Again thank you in advance.

Where do you want to save it for later use?

Thanks for the reply.

Basically I need to combine your code with RoyUK's.

The value needs to go to cell B16 as an example if it is selected to be copied. Or amended in row I where it exists already.

Does that make sense?

Thanks

In cell B16 please or anywhere as an example that I can use.

That is exactly what I want.

Sorry two more things if possible!

Can it instead of replacing cell B16 copy down the page each time an entry is selected and copied. Ie fist one copied goes to B16 the next to B17 etc?

Also, the contents of Textbox 1 will actually be sent using over code as the body of an email. However I cannot add returns on the text inside the box or do any formatting and the text doesn't wrap. Is there a better control to use rather than a Textbox?

Thank you once again.

Fantastic,

One very final point. I have changed the multiline property to True. When I enter text and press return it takes me straight to the first button. Firstly can this be stopped so it simply creates a new paragraph and the user has to physically select the button?

To get around it I have pressed Shift and Enter so I can create a new line within the textbox (to make it neater). When I do this and save it a square symbol appears instead of a simple blank return.

Is there any way around either of these points?

Thank you.