I am attempting to set up an Excel program that keeps up with member contributions to an organization, among other data.

I have a list of members which I use to populate a listbox in userform1. When we have a new member, there is a checkbox that can be clicked on which brings up userform2.

In userform2, the name and other information can be input. Once the okCommand button in userform2 is clicked, userform2 unloads and the listbox in userform1 is updated with the new member name.

Even though the new member name shows up highlighted in the userform1 listbox, the name is not recognized as the listbox value unless I click on it.

Is there a way in which the name can be recognized without having to take an extra step to click on the name? (Such a small thing to drive someone nutty.) Thanks.