MultiChoice Listbox

drltr6

New member
Joined
Oct 25, 2011
Messages
22
Reaction score
0
Points
0
Excel Version(s)
MAC 2011
I have a simple userform that enables the user to select up to 6 names from a list of 10. Is it possible to change the vba code to put the selected names in the order in which they were selected instead of the order that they are listed? Any help on this would be greatly appreciated.
 

Attachments

  • RosterChoice.xls
    68.5 KB · Views: 27
maybe use the Click event to build an array. The problem would be if you change your mind.

Another possibility would be to have a seconf listBox & populate that with the choices as you click
 
Thanks, I'll try to do that.
 
Back
Top