combo boxes

[CDnook]

I am trying to use a combo box which will provide a range of selections
depending on the value of a cell. If the cell say "Dallas" the combo box will
present different options than if the cell says "Houston".

 

[Luke M]

You'll need to use a named range. Look here:
http://www.cpearson.com/excel/named.htm

for ideas on how to write the formula that governs your range

You basically need a range that uses the OFFSET function, and is determined
by the value of your cell.(maybe some use of MATCH or LOOKUP?)