There are two types of listboxes, one from the Forms toolbar, the other from
the Controls Toolbox. They work similarly, and each has advantages.
Changing the controls toolbox listbox changes the value of cell A14 (named
CtrlTbxLink2) so it shows the selected value in the listbox. You can see
this if you show the Visual Basic toolbar, enter design mode (click on the
icon with the triangle and T-square) right click on the listbox, and choose
Properties. The name or address of the linked cell is shown in the
LinkedCell property. When this listbox is changed, it runs the
ListBox1_Change sub located on the Sheet2 code module (right click on the
Drop Down Chart 2 tab and choose View Code).
Changing the forms toolbar listbox changes the value of cell A21 (named
FrmTbrLink2), so it shows the index of the selected value. Right click on
the listbox and choose Format Control, click on the Control tab, and the
Cell Link box shows the name or address of the linked cell. Right click on
the listbox and choose Assign Macro to see which procedure runs when the
listbox is clicked. Click the Edit button in this dialog to see the
procedure.
In my code I've linked the two controls together, so they both always show
which chart is activated.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Gary" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi, thanks for your quick reply.
>
> I don't really know much about all this and I'm not sure what's going
> on from the downloaded example.
>
> It is the second worksheet functionality I need. Why are there two list
> boxes for the user to pick from?
>
> And where is the code assigned to?
>
> Thanks.
>
>
>
> Jon Peltier wrote:
>> Try these examples:
>>
>> http://peltiertech.com/Excel/Charts/...eDropDown.html
>> http://peltiertech.com/Excel/Charts/ChartByControl.html
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>> "Gary" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Hi,
>> >
>> > I'm not sure if what I'd like to do is possible, but hopefully someone
>> > will be able to help me out.
>> >
>> > I have an Excell 2003 workbook which contains various sheets. On one
>> > sheet I have 3 charts that are derived from data in the other sheets.
>> >
>> > I would like to give the user viewing the charts the option of viewing
>> > chart1, chart2 or chart3 individually, or, if required, all at once.
>> >
>> > I would like to do this with a drop down selction box that has the
>> > options chart1, chart2, chart3 and Show All.
>> >
>> > If chart1 was selected then the others would be hidden and so on.
>> >
>> > Is this possible?
>> >
>> > Thanks for any help.
>> >
>> > Gary.
>> >
>
Similar Threads
