Jumping to chart based on listbox selections
 

Hi everybody,

I am trying to create an interface that will allow users to find
particular chart based on their selections in 4 listboxs. The firs
listbox has 3 choices which correspond to 3 different workbooks. Th
second listbox selection corresponds to a worksheet. (all th
worksheets have the same names in each of the three workbooks.) Eac
worksheet has 40 charts which are sorted by 2 criteria. Then i woul
like to have a button that when pressed, will open the workbook an
display the selected chart. So, in summary:

1. choose workbook 1, 2, or 3

2. choose worksheet A, B, C, D within that workbook:

3. choose chart identifier I, II, III

4. choose chart identifier a, b, c, d

5. Display chart

Thanks in advance for any suggestions or advice,

Chri

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