Activate Embedded Chart from Listbox

**rstinson** · 11-28-2012, 01:15 AM

I'm fairly new to VBA but have built out the code to populate a userform listbox, select a chart, and export the chart if the worksheet is active. It works great. But, it can't find the chartobject if the worksheet is not manually selected first and results in a error. Is it possible to determine the sheet name for the embedded chart and pass that to a variable? My code is below to select the chart - simply, I'm trying to replace the "ActiveSheet" with a variable.

Please Login or Register  to view this content.

Thanks!
/Ron

**JosephP** · 11-28-2012, 03:30 AM

I reckon it's probably easiest to use a two column listbox and when you populate it with chart names add the worksheet name too in the second column-you can hide it if you don't want it displayed.

**rstinson** · 11-28-2012, 12:00 PM

Thanks JP for the response. That's where I'm unclear - does the embedded chart include its worksheet name? Or, are you suggesting that the user select the worksheet and then select the chart in the listbox?