View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tbieri tbieri is offline
external usenet poster
 
Posts: 8
Default 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