Combo Box Question

[Scott Jacobs]

Without using data validation, is there any way to dynamically define a
range for a combo box placed on a worksheet from the "forms" tool bar?
Meaning that the range for the combo box needs to increase as more data is
added to the spreadsheet. If not, if I were to add a combo box to the
worksheet from the "control toolbox" how do I get the combobox to add a cell
link to the spreadsheet so I can query the data based on the selection in
the combobox.

Please provide sample code.

Any help is greatly appreciated!!!

Thanks,

Scott J