How do I select and display multiple entries?

Hello sunny17,

I have added a UserForm that displays the names of the testers on "Sheet1". Each selection in the ListBox has a checkbox next to it. Once the choices are made, the user clicks the "Enter" button. The names are then transferred to the active cell in column "F" as a comma separated string.

There are several parts to the workbook: A UserForm, a module, and the Worksheet Selection Change event. The UserForm lets the user select the testers, the module contains the macro to display the UserForm, and the worksheet event validates the user is in column "F" before displaying the UserForm.. Here is the all the code that has been added to the attached workbook.

UserForm Code

Please Login or Register  to view this content.

Sheet1 Worksheet Selection Change Event

Please Login or Register  to view this content.

Module1 Code

Please Login or Register  to view this content.