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

--
Message posted from http://www.ExcelForum.com

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...46&Product=xlw
XL: Using Defined Names to Automatically Update a Chart Range

If you want code:

http://support.microsoft.com/default...40&Product=xlw
XL97: How To Create a Dynamic Chart Using Visual Basic

http://support.microsoft.com/default...80&Product=xlw
XL2000: How to Use Visual Basic to Create a Dynamic Chart

http://support.microsoft.com/default...55&Product=xlw
Using Visual Basic to Create a Chart Using a Dynamic Range



--
Regards,
Tom Ogilvy

"bkey01 " wrote in message
...
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 to
selection in a listbox on a master sheet.

Help!!
Thanks


---
Message posted from http://www.ExcelForum.com/