I'm experienced with Excel & VBA, but new to using Excel to create a form.

I would like to simply use a cell as a drop down. Not knowing if that is
possible, I have added a combo box to the spreasheet, but I am unclear how
the data entered/selected in the drop down will be stored. Is it stored as a
VB variable associated with the control or do I link the control to a cell to
store the data? To define the values in the drop down/combo box, do I have
to use cell references or can I write in the values in the properties
(writing them in hasn't worked for me)? Finally, what property do I have to
set for the combo box (ActiveX control) to automatically move & size with the
cell?

Direct answers, links to web sites, any help is greatly appreciated. Thanks
in advance.