Is there a way to do a drill down to fill in a cell? I
need a combo box that will work as a tree.

Is the tree view usable and if so .. can someone
send/point me to some code.


Example

Select colors

Primary
Red,
Green,
Blue
Secondary
Pink
Orange
Yellow


ther notes: Using office 2002

Thanks in advance,

Stewart Rogers