indirect in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Tnanks, but I figured out another way, going back and forth between VB and
the worksheet itself. Unfortunately, due to the size of the data set, screen
updating is rather slow, but the chart display flickers too much if I turn
off screen updating. Thanks for you help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect formula errors if file is closed 1
VBA userform Vlookup Excel 1
VLookup and Indirect 3
INDIRECT Syntax 1
VBA equivalent for Excel "indirect()" function in UDF 8
Indirect & Named Range 6
VBA does not recognize Excel worksheet function "indirect" 2
Excel Excel 2010-Vlookup, Indirect, Workbook Reference 1

Back
Top