Populate Userform with items in a range so user can edit

I have a userform where users enter in items that will become their drop-down menus. The form works great!

This is the code for that form:

Please Login or Register  to view this content.

However, now I want to add a different form where users can edit this drop-down list. So if they later want to delete or add an item they can. So I need the userform textbox to populate with their current drop-down list (each item on a separate line). Then a user can edit that textbox, and then when they click submit it will be the same previous code so it will create their newly edited list.

This is my poor attempt:

Please Login or Register  to view this content.

But when I click on the form, there is just a blank textbox. I knew this code wouldn't work. It was my poor attempt.

I just need the form to already have their list in the textbox. And then they can modify that list any way they want, and then on submit, I will have the same code as before.

Any ideas on how to get the textbox to show the content found in that range, each item showing on a different line.

You Should use a listbox for that sort of job.

Please Login or Register  to view this content.

You can then programme the click event to remove an entry. You need to do something to prevent the whole listbox being emptied though.

Please Login or Register  to view this content.

I named my UserForm EditClient

That doesn't matter, leave it as is.

Please Login or Register  to view this content.

is to be put in userform module no matter what name the form has.
It is object related, not name related.

Are the names TextBox1 and ListBox1 the names of your objects ?

I have two userforms.

Original one: Enter Clients has a textbox named textbox2, and then the VBA code that on clicking the submit button puts the items in the textbox in the clients named range.

This new one: Edit Clients, which just has the listbox that auto-populates what is in their clients named range, and then they need to be able to edit it.

So is the new form supposed to have a textbox too? Sorry, I am not familiar with listboxes. So I just thought you meant replace the textbox with a listbox.

Why would you need two userforms to add or edit clients ?

Just add a listbox and a commandbutton to your original.Then use the listbox to select a client you wish to edit. All textboxes get filled with client information.

Edit the required textboxes and with the new commandbutton write the changes to the worksheet.

Post an example file with your userform and some dummy info if you have trouble adapting your current userform.

I need the original one because nothing is in the client range yet. The first userform is where they first create their user list. Then months or years later, they may want to delete or add one to the list, so then there is the edit userform.

The first userform populates and creates the client range (which is a named range using offset since I don't know how many clients they will enter in). At the start, there is just a 1 in the first cell of that range to act as a dummy placeholder.

The user then clicks on create client list and enters in their clients (the 1st userform), and it then puts them into the named range, clearing out the dummy 1, and puts them in alphabetical order.

I put in Test, Does, This, Work. It then created my client list.

Then I have a second userform for the user to then edit their client list later on down the road. This is the one you were helping me with.

So I added a textbox to the edit userform.
Initial form.png

When I click on "does," it goes to the textbox.

1 added.png

When I click on "test," "this," or "work," nothing happens. I kept clicking to try, and eventually, it would go there, but it would delete "does," and just add a different one.

I was hoping the user could just edit the textbox.

So if it comes up with
"Does"
"Test"
"This"
"Work"
but the user no longer works with "test," they can just delete it from the list. And if they now work with "crazy," they can add it to the list. So then their new list is "does," "this," "work," "crazy."

This is my first introduction to a listbox. It seems I can't delete something from the listbox by just highlighting it and deleting it, and I can't add anything to the listbox. So I guess instead of my original idea of a user just deleting an item or adding an item won't work. Instead, I guess they will need to double click on everything in the listbox that they still want to keep to add it to the textbox (thereby deleting the ones they don't want), and then add to the textbox any new entries. Seems extra cumbersome. But as I said right now they can't even select things in the listbox to go into the textbox beyond just one item.

As I said post an example file with your userform and code you're currently using.
To do so click on Go Advanced, scroll down to Manage attachments, click Select File, click Upload and then Submit.

Select the names you want to delete in ListBox (multiselect) and press Edit list.
The remaining names appear in Textbox. Now you can add or leave it as is.
Clicking Submit button writes new list to worksheet.

Glad to help and thanks for rep+.