linking multiple workbooks (VBA)

B

bkey01

Can someone please help me with linking multiple workbooks to a listbox
I have 32 excel workbooks full of charts and I want to link each t
selection in a listbox on a master sheet.

Help!!
Thank
 
T

Tom Ogilvy

What are you trying to link. If you want the charts to change based on the
selection made in the listbox, then you would set up a defined name in each
workbook with charts that references the cell the listbox is linked to.
Have this defined name refer to a dynamic formula that defines the data to
be referenced. Then make this the source for your chart.

Other than that, you would need to provide more details on what you mean by
link.

Some references:
The easy way is to use named ranges defined by formulas - dynamic ranges:

http://support.microsoft.com/default.aspx?scid=kb;en-us;183446&Product=xlw
XL: Using Defined Names to Automatically Update a Chart Range

If you want code:

http://support.microsoft.com/default.aspx?scid=kb;en-us;157940&Product=xlw
XL97: How To Create a Dynamic Chart Using Visual Basic

http://support.microsoft.com/default.aspx?scid=kb;en-us;213780&Product=xlw
XL2000: How to Use Visual Basic to Create a Dynamic Chart

http://support.microsoft.com/default.aspx?scid=kb;en-us;146055&Product=xlw
Using Visual Basic to Create a Chart Using a Dynamic Range
 

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

linking multiple workbooks - UPDATED 3
Who is linking to my file? And what files am I linking to? 1
linking multiple workbooks 1
Create an array of all open workbooks 3
Unwanted workbooks on startup 2
Populate a list box with all active workbooks except the current one. 7
Macros to extract data frommultiple workbooks to a master workbook 0
Update #REF! to Active Workbook 1

Top