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.:

--
Message posted from http://www.ExcelForum.com