VBA Concatenate and listbox

  • I have 2 columns, one with a last name the other with a first name. I need to concatenate them into a third column (last name, first name) in a way that when I add a new name the third column will automatically update with the concatenated name. It needs to be done using VBA, but I haven't the slightest clue where to start.
    Also the third column will be loaded into a listbox so that when I select a name a a number they have been assigned will pop up as a label caption. Any one know of anyway to do this? Hope that kind of all made some sense to somebody. Thanks for taking the time :)

  • Re: VBA Concatenate and listbox

    Hello bellshell, and welcome to the forum! :)

    For the first question, right-click on the sheet tab, view code. Paste this in.

    Adjust the column references if necessary. For the latter question, we'll need a lot more information. Where is the listbox, how do you want the information loaded? Could we just use a dynamic range that populates the listbox?

    Best Regards,
    Luke M
    "A little knowledge is a dangerous thing."

  • Re: VBA Concatenate and listbox

    Thanks that helps a lot! I was able to kinda figure out what I wanted to do with the second part of that. Appreciate it!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!