VBA: Link Chart Title to Drop Down Menu

[toddanderson1]

What is the code used to grab the title of a chart from a drop dow
menu?

For example I choose "Adams County" from the drop down menu. I hit th
go button, the data appears i need a chart for. I hit create chart.
It makes the chart but I need it to automattically include "Adam
County" from the drop down menu as the chart's title.

Any help is appreciated.

Thanks.:

 

[Frank Kabel]

Hi
try
- select the chart title box
- hit F2 or click directly in the formula bar
- enter the equation sign '=' and select this cell

 

[toddanderson1]

I actually need the name from the dropdown menu. The name doesn'
appear in a cell. It's not possible to = and then select a name fro
the drop down menu.




Thanks for your help .:

 

[Frank Kabel]

Hi
so you're not using 'Data - Validation' to create this combo box. I
would suggest you link your drop down to a cell (you can hide this
cell) and link this cell to the chart title.
Without this you'll need VBA