Add New Item to a MultiSelect Listbox, Auto-Select the New Item and Selected Items

  • I've struggled trying to word this in a way that would let me find an answer with my usual google-fu, but here goes...

    I have a Userform with a MultiSelect Listbox, which is used to select the team members for a project. The Listbox Items are added with a dynamic named range RowSource (in code, not a fixed property of the Listbox.)
    Users have the option to select the "Add New" item, which launches a separate Userform to populate the new information for a new Team Member. This works fine, and the info is automatically entered into the source data sheet in the correct location - so the dynamic named range updates.

    The issue I have is that I can't get the original Listbox to update correctly.
    I would like the Listbox to:
    Refresh the list to add the New Team Member (this works using the dynamic named range)
    Retain the Selected items that were selected before the User clicked on "Add New" - I have tried to do this by creating an array from the Selected Items, then matching them against the 'refreshed' source.(this fails completely.)
    And Select the New Team Member (this also fails...)

    Any suggestions greatly appreciated!

    Thanks, Nick

Participate now!

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