I have a UserForm with 3 ListBoxes from which the user makes selections, and the resulting selections appear in specific cells on an Excel Worksheet ("list"). ListBox1 (LB1) is a multiselect, while the other LB's are single selections. When I call up the UserForm all 3 LB's populate fine. My selections off LB2 and LB3 appear on the worksheet as they should, however I am having problems with the selections off LB1. The selections don't appear. Ideally I'd like to limit the selections off LB1 to only two, and I want these to appear in cells A20 and A21 on my "List" sheet.
I'm using Excel 2003
I appreciate any direction.
Here's my code for this listbox:
Thank you,
Bookmarks