View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I create a combo box that is tied to another combo box?

Could you live with Data Validation dropdown lists instead of combocbox?

See Debra Dalgleish's site for how-to and a sample workbook.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Wed, 9 Dec 2009 10:26:03 -0800, rosamaria <rosamaria
@discussions.microsoft.com wrote:

I am trying to create a combo box that is associated with yet another combo
box. So, for example, I have a combo list currently, but I'd like another
list (a sub-list) to pop up with each input in the combo list. Is this
possible?