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

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
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
 

drltr6

New member
Joined
Oct 25, 2011
Messages
22
Reaction score
0
Points
0
Excel Version(s)
MAC 2011
Thanks, I'll try to do that.
 
Top