Hello.
I am a newbie with perhaps a very silly first question!
I am attempting to build a report with a graph where rather then use multiple check or option boxes to select and deselect criteria to switch formula on and off to graph, to use a Form control listbox (with selection type as "Multi") so that they can select multiple criteria from there to chart the information.
I have used a listbox from the Developer/Insert/Form Controls menu and have populated it with a list of 14 criteria to select from and checked the Selection Type as "Multi" so that multiple items can be selected to graph and after that this is where I become lost.
How would I go about getting the list box to populate the criteria selected within it into a spreadsheet in the excel workbook where I could then reference formula to the selections and bring back data to graph so I can make my graph dynamic?
Any help much appreciated.
Thanks.
I am a newbie with perhaps a very silly first question!
I am attempting to build a report with a graph where rather then use multiple check or option boxes to select and deselect criteria to switch formula on and off to graph, to use a Form control listbox (with selection type as "Multi") so that they can select multiple criteria from there to chart the information.
I have used a listbox from the Developer/Insert/Form Controls menu and have populated it with a list of 14 criteria to select from and checked the Selection Type as "Multi" so that multiple items can be selected to graph and after that this is where I become lost.
How would I go about getting the list box to populate the criteria selected within it into a spreadsheet in the excel workbook where I could then reference formula to the selections and bring back data to graph so I can make my graph dynamic?
Any help much appreciated.
Thanks.