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

Here is the info on how to use the tree view:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/vbcon98/html/vbconusingtreeviewcontrol.asp

-----Original Message-----
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
.