Creating a drop down menu basics

I am trying to create a drop down menu in an excel worksheet, but am having trouble entering the source.  When I try the formulaic approach eg. =Catagories(A2:A9) I get exactly that as the drop down ...