Recalculate sheet & Positioning text boxes

  • Thread starter Thread starter George Andrews
  • Start date Start date
G

George Andrews

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
 
Note sure about the second question, but the for your first question,
use the Worksheet_Change Event. Something like

Private Sub Worksheet_Change(ByVal Target as Range)
Application.Calculate
End Sub

Or even just get rid of the Application.
 
Back
Top