Hello!
I used this to create a userform multi-select listbox to select pets:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=369
Then, I used this to output the listbox's selections:
http://www.ozgrid.com/VBA/multi-select-listbox.htm
That's as far as I got.
1) I would like to use the output like I show in H18:
The pets selected are XXX, XXX, XXX, and XXX.
2) Instead of referencing Sheet 2 cells A2:A100 in the code, I would rather use the named range for that area
"Pets" (which refers to A2:A100). That way, I don't have to change the code if the pet list grows past 100.
Hopefully, this is an easy fix.
I appreciate your help!
VR/Lost
Bookmarks