Hi.



I've been trying to apply http://peltiertech.com/link-excel-ch...lues-in-cells/ to my spreadsheet. But it's not working and I can't puzzle out what the problem is.

Long story short I want the chart to update the X-min/Max and Y-min/max if the user changes the values in cells B7/B8/B9.

What am I doing wrong?

/Møller

Attached Files

ARZ, Excel, Testing3.xlsm (22.9 KB, 12 views)

The code needed to be in the sheet concerned's code-module and there needed to be a few tweaks to the code.

Attached Files

msofficeforums31906ARZ, Excel, Testing3.xlsm (24.3 KB, 18 views)

Thanks a bunch mate.

What is the difference between the having the cells in () and []?

Also, why should the code be under the sheet and not in the module?

These probably really basic questions but I haven't got the foggiest what I'm doing...

/Møller

Square brackets is short for Evaluate.
It's an event handler so needs to know which sheet the event occurs on.

Excellent. Problem solved.