Way to change combocbox values using name manager

[subbby]

a more detailed and elaborate question of what I asked on link http://www.excelforum.com/excel-prog...16#post2919716


What I Have :

• I have defined some names to a certain group of cells, using Name Manager (Or by selecting the cells and declaring a name in the name bar)
• Each name defined in the name manager (means, each group/set of cells) is associated with one name.

Eg .

• Cells: A2:A10 are under the name – DingDongBell

All these fall under the category BELL

• Cells : A12:A15 are under the name Electronics

All these fall under the category Computers

• Cells: a20:a30 ARE UNDER THE NAME – Busses

All are under the category Transportation




Of which Bell, Computers and Transportation are the values in Combox1

What I Want ?

1. If the user selects, Bell, : under combobox2 I want all range of cells under the name DingDongBell be displayed.
2. If a user selects Computers in combox1, I want all values in combobox2 to be keys, USB Mouse, moutheboard,3-D Mouse (whic are nothing but range of cells named as electronics)
3. If a user selects Transportation in combobox1, I want all range of cells under the name Busses to be displayed in combobox2

Pls Note : I WANT to AVOID IF….statement…. the categories (Bell, Computers and transporation is just 3 of the never ending long list)

Attached Excel sheet. Pls view the name manager (Ctrl+F3)

DISCUSSED BY ME http://www.ozgrid.com/forum/showthread.php?t=169572