Combo box, List box, Validation
 

I'm using Office 2000, and I've created 2 list boxes in a ss. The 2nd box
presents a different data list based on the result of box 1, using Data
Validation. Box 2 looks at the result of box 1 using: =indirect(b2). This
works fine.

But, a List Box loses the scroll arrow when cell is not active, so it is not
immediately clear that there are other possible selections. A Combo Box
nicely shows the scroll arrow, which is what I would like.

Problem
So I tried combo boxes, putting =indirect() in combo box2, pointing back to
the value combo box1 puts in the link cell. But I get a popup saying the
reference is not valid.

Then I tried to use a List box following combo box1, but it does not
recognize the value combo box1 puts in the link cell.

So, am I stuck using 2 list boxes? Is there any way to use combo boxes to
do this w/o vba code?

Alex