I'm not sure what you mean by "I just can't get a ComboBox in a Toolbar
to work properly when a chart is active." If you mean it should be
active only when a chart is...

One 'trick' is to create an event hook that ties to a toolbar button
that XL enables whenever a chart is the active element (if you can find
such a commandbar item). This technique is further explained in
Professional Excel Development by Bullen, Bovey, and Green.

Another approach would be to add to your ComboBox code something along
the lines of
If activechart is nothing then
msgbox "Sorry, please select a chart first"
exit sub
end if

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
How do you create a custom toolbar with a ComboBox that will be avaliable
when a chart is active?

I'd like to have a TOOLBAR where a ComboBox (or ListBox) is used to select a
variable. This would then change the source data for the chart. I've got
the code to change the chart, I just can't get a ComboBox in a Toolbar to
work properly when a chart is active.

Tx,
Randall