On Tue, 3 Nov 2009 13:28:01 -0800, cm
wrote:

I would suggest using a data validation list rather than a combo box. Create
your list and then refer to the list as follows:

Choose Data Validation (on the Settings tab) Allow 'List' and then in the
'source' box you will put the cell references for your list values.


I make an array of cells containing the desired drop down box list, and
then NAME that array.

You can name several, actually, and then validate to that named range
in the validation dialogs, as in: =RangeName

Where "RangeName" is equal to the named range "name" you gave it.

If you want it to be dynamic, you can use =INDIRECT() to assist with
that.