.... pressed Send too soon.

You can use a control to run a macro. Right click on a Forms toolbar
control and select Assign Macro from the pop up menu. Right click on the
Control Toolbox control and select View Code, then use the right hand
dropdown at the top of the code window in the VB Editor to select the
event you want to fire.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:

I have a chart (ChartSheet1)which populates based on a drop down box.
The drop down box sends a variable to Sheet2. Chartsheet1 range feeds
from Sheet2 based on this variable.

How do I use a WorkSheet_Change event to track the change in the
variable in Sheet2 so that I can modify the formats and title of my
chart?

RK