Combobox in Excel

[fkheng]

I am using Microsoft Excel 2000. Although this is a VBA section, I just would like to know if it is possible, without the intervention of VBA, to have a combobox within a cell in an Excel sheet, so that the user can choose a pre-defined selection from a combobox list. Is this possible? (I am not referring to the "Right-click" & "choose Pick From List" as this gives a whole list of previously inserted information.)

[WorkHorse]

Use data validation. In Excel, select the cell that you want to have the drop-down. Go to Data, then Validation. Under Settings, set the Allow field to List. Then, under Source, selet a range of cells to use in the drop down list, or type a comma-delimited list of values. Click OK. :)