Recalculate sheet & Positioning text boxes
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 |
Recalculate sheet & Positioning text boxes
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. *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 07:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com