(Msg. 1) Posted: Wed Nov 04, 2009 6:49 am
Post subject: TextBox linked to cell????? Archived from groups: microsoft>public>excel>misc (more info?)
I am trying to link a textbox to a cell that has a formula. Ideally the value
of the textbox changes everytime the value of the cell changes. But the
problem I am having is the the cell has a formula which get erased every time
the value changes.
The cells(J187) formula is as follows: =SUM(J69:J186)
TextBox9 displays the value of cell "Sheet2 J187"
I need it to change as cell J187 changes.
Any ideas
(Msg. 2) Posted: Wed Nov 04, 2009 7:08 am
Post subject: RE: TextBox linked to cell????? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I have manage to sort the problem by adding the following code in sheet2. As
the value in cell "j187" changes it changes tha value in textbox9.
Private Sub Worksheet_Calculate()
Application.ScreenUpdating = False
Sheets("Sheet2").Range("j187").Copy
Sheets("Sheet2").Range("j188").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
End Sub
"hoyos" wrote:
> I am trying to link a textbox to a cell that has a formula. Ideally the value
> of the textbox changes everytime the value of the cell changes. But the
> problem I am having is the the cell has a formula which get erased every time
> the value changes.
>
> The cells(J187) formula is as follows: =SUM(J69:J186)
> TextBox9 displays the value of cell "Sheet2 J187"
> I need it to change as cell J187 changes.
> Any ideas
(Msg. 3) Posted: Wed Nov 04, 2009 7:11 am
Post subject: RE: TextBox linked to cell????? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
A tiny trick!
1. create the text box (or any other shape from the drawing toolbar!)
2. click on the shape, but don't type in it
3. click in the Formula Bar and enter:
=J187
If you put the formula in the Textbox, Excel would treat it as just Text.
--
Gary''s Student - gsnu200908
"hoyos" wrote:
> I am trying to link a textbox to a cell that has a formula. Ideally the value
> of the textbox changes everytime the value of the cell changes. But the
> problem I am having is the the cell has a formula which get erased every time
> the value changes.
>
> The cells(J187) formula is as follows: =SUM(J69:J186)
> TextBox9 displays the value of cell "Sheet2 J187"
> I need it to change as cell J187 changes.
> Any ideas
(Msg. 4) Posted: Wed Nov 04, 2009 8:10 am
Post subject: RE: TextBox linked to cell????? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Gary, I tried that but it did not like it at all.
The formula I'm using seems to work ok. I suppose I can just add more cells
tpo that code?
"Gary''s Student" wrote:
> A tiny trick!
>
> 1. create the text box (or any other shape from the drawing toolbar!)
> 2. click on the shape, but don't type in it
> 3. click in the Formula Bar and enter:
>
> =J187
>
> If you put the formula in the Textbox, Excel would treat it as just Text.
> --
> Gary''s Student - gsnu200908
>
>
> "hoyos" wrote:
>
> > I am trying to link a textbox to a cell that has a formula. Ideally the value
> > of the textbox changes everytime the value of the cell changes. But the
> > problem I am having is the the cell has a formula which get erased every time
> > the value changes.
> >
> > The cells(J187) formula is as follows: =SUM(J69:J186)
> > TextBox9 displays the value of cell "Sheet2 J187"
> > I need it to change as cell J187 changes.
> > Any ideas
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office