Here's the situation. I have a class module for an embeded chart which
generates a text box when I mouse over any point. I would like the text box
to reference some information that is gathered via a VLOOKUP. The problem is
that the table array changes based upon several pull down boxes I have. I
can generate the appropriate range reference on a worksheet, then pull out
the required data using INDIRECT in the VLOOKUP function. How do I do this
in VBA?

Wazooli