I'll link to Jon Peltier's chart example for your review:

http://www.peltiertech.com/Excel/Zips/ControlChart.zip

On the data entry screen, it indicates to press F9 to refresh the data, but
I can't figure out what macros are run when F9 is pressed. How do I know?

Thanks in advance,
Barb Reinhardt

F9 triggers recalculation. In the VBA editor, if you double click on "Sheet1
(Control Chart)" you will see a small sub that is triggered by the
Workseet_Calculate event, and which calls a couple of subs in the modRunChart
module.

Jerry

"Barb Reinhardt" wrote:

I'll link to Jon Peltier's chart example for your review:

http://www.peltiertech.com/Excel/Zips/ControlChart.zip

On the data entry screen, it indicates to press F9 to refresh the data, but
I can't figure out what macros are run when F9 is pressed. How do I know?

Thanks in advance,
Barb Reinhardt

It was the "Worksheet_Calculate" event that I didn't catch. Thanks.

"Jerry W. Lewis" wrote:

F9 triggers recalculation. In the VBA editor, if you double click on "Sheet1
(Control Chart)" you will see a small sub that is triggered by the
Workseet_Calculate event, and which calls a couple of subs in the modRunChart
module.

Jerry

"Barb Reinhardt" wrote:

I'll link to Jon Peltier's chart example for your review:

http://www.peltiertech.com/Excel/Zips/ControlChart.zip

On the data entry screen, it indicates to press F9 to refresh the data, but
I can't figure out what macros are run when F9 is pressed. How do I know?

Thanks in advance,
Barb Reinhardt

"Barb Reinhardt" wrote:

It was the "Worksheet_Calculate" event that I didn't catch. Thanks.

You're welcome, glad it helped.

Jerry