Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Event and Calculated cells
Howdy;
I am interested in using the worksheet code to look at two cells, which in turn become the X-axis scale max/min. The cells are calculated, and based on Cpearson.com, Change Event does not fire from calculated cells. Ultimatley the cell changes based on the user selection from a Form dropdown. For example, the dropdown contains 7 day, 30 day, 90 day options and the changing cells find the right begin/end dates. I have the whole process working based on dyanmic ranges, but it seems cleaner/easier to graph the whole dataset and adjust the scale limits. Regards, Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change event macro to add cells | Excel Worksheet Functions | |||
how to change a calculated cell to = the calculated value | Excel Discussion (Misc queries) | |||
Custom Function not being auto calculated when cells change..help? | Excel Worksheet Functions | |||
Chart Values that change based on Change event | Excel Programming | |||
change event/after update event?? | Excel Programming |