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