Creatibg A List Box In Excel 2002 2

[FontanaS]

i am having trouble creating a list box for every row in a column.

I have a column called "Forecast Methods". The user will be entering multiple rows of data (there are other columns). For this column, the user wants a combo box that will only allow certain values. I created the list on another sheet and named the data range "Methods".

How do I create a list box that refers to those values on another sheet and is on all ofthe rows?

THANKS!

 

[jfhewitt]

Check out "Data/Validation". List may be contained on another worksheet in the workbook.

 

[KenWright]

Note that in order to use D/V with a list that is on another sheet, you need to name the list and then reference the name using =your_list_name in the refernce box.

You will not be able to hit the reference icon and simply browse to another sheet.

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------