Formatting

http://office.microsoft.com/en-au/excel-help/add-a-list-box-or-combo-box-to-a-worksheet-HP010236681.aspx

Hi Tina,

Please find attached a link that will step you through how to create list box. This is reasonably advanced and it would help if you had some VBA experience to create that.

Another options you use a combo box and they are much easier to create.

Step One:

Create your list. If you are using 2007 and the list is on another sheet than the question then you will need to name that list. To do this use the NAME BOX.

Step Two:

Go do DATA VALIDATION and select LIST and the in the SOURCE find your list or enter =plusthenameofyourlist

This will add a drop down combo box to the cell you are working on.

I hope that helps?

Thanks
Paul