combo boxes

  • Thread starter Thread starter CDnook
  • Start date Start date
C

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".
 
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?)
 
Back
Top