Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink in same sheet - positioning problem | Links and Linking in Excel | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
How do I set Excel to recalculate a sheet on a frequency (5 sec)? | Excel Discussion (Misc queries) | |||
text box positioning, printing and between loads | Charts and Charting in Excel | |||
Calling Text Boxes from a sheet | Excel Programming |