Hi Newbie16,

Check this out, maybe it will help:

1st - On a separate tab that you can hid later put the data that you
want in a column, like this:
A1= 1
X
3
2
5
X

Now on your top Toolbar go "Insert" ~ "Name" ~ "Define"

Define Name Box will open
In the "Names in workbook" let's type "Data" for this purpose. Go to
the bottom of the box to "Refers to:" and select the data you want to
appear in the list box ... will look something like this
"=Sheet2!$A$1:$A$6"

Finally, on the right side of the box click "Add" and then "Okay"


2nd
Go to the tab and cell with you want the list box
Now on your top Toolbar go "Data" ~ "Validation" and "Settings" tab

In the "Allow:" box select "List" then in the "Source:" box type
=Data (if you choose another name when you defined the data then
it will be ="Your Name"

Click okay and your set