Populate a textbox in a userform using multiple selections from a combo box

**kksf** · 05-23-2013, 10:16 AM

Hi there,

I've been racking my brains (and forums) trying to figure out how to solve my problem.

I am currently building a userform, where people can select more than one object/value in a combo box that will automatically populate the textbox I select.

At the moment, the textbox is populated with the value that is selected at that time in the combobox, but when I try to select a second value, the original one gets replace.

Is there a way for allowing multiple entries into the textbox, and separating the entries with a comma.

The current code I have (which works is):

Please Login or Register  to view this content.

Thanks in advance.

**JBeaucaire** · 05-23-2013, 10:20 AM

You set the value = the value it currently is AND append the new value. I'm just guessing at your code, don't fully understand it, but this example should give you the idea:

Please Login or Register  to view this content.

**kksf** · 05-23-2013, 10:52 AM

That's worked great so far, however it starts the values in my textbox with ", ". Is there a way of putting an If command so that I can put an initial entry in there from the combo box, and then add onto the existing ones in there once they're selected?

Thanks!