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