i have several charts with textboxes lind to specific cells within my
workbook. inside these cells are formulas that calculate values that I am
trying to display on my charts in the text boxes. My calculations are set to
automatic, but these text boxes are not updating unless i click in the
formula bar for each of them and hit "enter." since i have several charts i
don't want to be doing this hundreds of times a day. I have a total lack of
confidence that my chart text boxes are displaying the correct values. is
there some way to force them to update, maybe with some vba code? thanks in
advance.

L.B.

Try running this macro:

Sub UpdateIt()
Application.CalculateFullRebuild
End Sub

--
Gary''s Student - gsnu201001


"lbbeurmann" wrote:

i have several charts with textboxes lind to specific cells within my
workbook. inside these cells are formulas that calculate values that I am
trying to display on my charts in the text boxes. My calculations are set to
automatic, but these text boxes are not updating unless i click in the
formula bar for each of them and hit "enter." since i have several charts i
don't want to be doing this hundreds of times a day. I have a total lack of
confidence that my chart text boxes are displaying the correct values. is
there some way to force them to update, maybe with some vba code? thanks in
advance.

L.B.

That seems to work for the cells in my worksheets, but not the text boxes on
my chart.

"Gary''s Student" wrote:

Try running this macro:

Sub UpdateIt()
Application.CalculateFullRebuild
End Sub

--
Gary''s Student - gsnu201001


"lbbeurmann" wrote:

i have several charts with textboxes lind to specific cells within my
workbook. inside these cells are formulas that calculate values that I am
trying to display on my charts in the text boxes. My calculations are set to
automatic, but these text boxes are not updating unless i click in the
formula bar for each of them and hit "enter." since i have several charts i
don't want to be doing this hundreds of times a day. I have a total lack of
confidence that my chart text boxes are displaying the correct values. is
there some way to force them to update, maybe with some vba code? thanks in
advance.

L.B.