Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jumping callout shapes in a chart | Charts and Charting in Excel | |||
Creating Chart from Userform ListBox selections | Charts and Charting in Excel | |||
Sum based on two selections - months | Excel Discussion (Misc queries) | |||
total amount based on selections of 1-9, 10-19 and 20-30 | Excel Discussion (Misc queries) | |||
changing foreground color of listbox w/o losing selections | Excel Programming |