Hi,
This post was almost done when Charles posted his reply. Any duplication is purely accidental and merely confirms that he is right i the first place.
Listboxes are available in Excel 2003, too. Bear in mind, however, that they are user interface tools in either version, meaning that they transport data between the user and a program that processes them. I think you have the user but what about the program? Perhaps the need will become more clear as you go along.
Start with a blank worksheet.
Enter your list of 8 choices (or more), vertically, in a column of adjecent cells.
Name the list as something, why not "List". To do so, select the range containing your list and write the name in the Name Box at the top left of your screen. Remember to "Enter".
Right-click anywhere in the blank area of your toolbar.
From the dropdown that appears select ControlToolbox.
The "Toolbox" is a toolbar which opens floating. You can drag it to a side or edge if it bothers you.
Find the icon for the "Listbox" in it and click on it.
Draw a rectangle of the size of the listbox that you want somewhere on your sheet.
The Listbox will be created as you release the mouse button.
It will be selected. You can delete it. Or you can drag its handles to adjust the size.
The most important part of it isn't even on the Listbox itself. It is the button on the Control Toolbox in the upper left corner. When you hover the mouse over it, it says "Exit design mode". When you exit design mode the listbox becomes functional. While in design mode you can modify it. You can toggle this button on and off.
Right-click anywhere in your Listbox while in Design Mode.
Select Properties from the dropdown.
If you know what you are looking for, use the alphabetical listing. For fishing exepitions you may prefer categorized listing of the properties. Select the tab you want. The number of items isn't smaller in either display, but you don't need to set them all.
Enter the name of your list against ListFillRange (Now you see your list in the box).
Set MultiSelect to fmMultiSelectMulti (this is a dropdown selection)
Set ListStyle to fmListStyleOption (another dropdown)
That is all. You can play around with the other properties if you are so inclined. But if you exit design mode now you have a fully functional Listbox that does exactly what you want it to do.
If you get this far you may come back to this forum to get some help on filling the data from the listbox to the worksheet where you want it.
Have a great day!