A drop down list will only return one of the selections in that list. Unless you have tennis and basketball on the same line, you cannot select more than one. That would be a great feature. Excel offers this in their drop list allowing for multiple entries.
To do this you need to have check boxes. Because of the many sports that might be listed, screen real estate is an issue. You might consider a new layout just for the sports selections. The user selects their favorite sports and a new layout appears with all of the choices. They can check one or many and the results are copied to the field or fields as you would prefer with a script that also returns them to the original layout.
Programming these features sometimes is like working with FM limits and producing the desired results. The second layout can be a duplicate of the first layout, excepted that the appearance of a drop down menu is display. The first layout could be a drop down menu, but a script is attached to it to move you to the second layout. The second layout has a drawn drop down menu, that contains the check boxes. A Go button or something would indicate to the user I'm done, a the script on the go button, switches back the first layout and copies the results as desired.
I hope this helps.
Marty
