figured it out. I just needed to name the range containing the
list. at that point you can just type the name in the source field.

but if you click onthat the icon to the right it will not
let access anything by the sheet you are on

"ryguy7272" wrote:

It's not a function, it's a ComboBox. Check this out:
http://www.excel-vba.com/vba-forms-3-7-combo-boxes.htm

As an alternative, you could try Data Validation:
http://www.contextures.com/xlDataVal01.html

HTH,
Ryan---

--
RyGuy


" wrote:

what is the actual function for a drop down list.
I know how to it through the data validation tab,
but If new the actual formula I think that would help
solve my problem