Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Question Jon Peltiers Control Chart Example
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Question Jon Peltiers Control Chart Example
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Question Jon Peltiers Control Chart Example
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
General Question Jon Peltiers Control Chart Example
"Barb Reinhardt" wrote:
It was the "Worksheet_Calculate" event that I didn't catch. Thanks. You're welcome, glad it helped. Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
General question | Excel Worksheet Functions | |||
A VERY General question | Excel Worksheet Functions | |||
Pivot / general chart formatting question | Charts and Charting in Excel | |||
General chart set up question | Charts and Charting in Excel | |||
General Question | Excel Programming |