Excel 2000

Hello

I have managed to put some results into Text Boxes by refering to cells
where I have some worksheet functions.

This works fine except for two things:

1) I have to recalculate the page by pressing on F9 every time I change
cell.
2) The Text boxes move off the page if I scroll down

Questions:
a) How can I automatically recalculate the page every time I change cell
and
b) I would like the Text Boxes or Group of Text boxes to move to next to the
cell that I am clicking on.

Any help appreciated.

Regards

George