excel not updating text boxes

excel not updating text boxes

Post by bGJiZXVybW » Fri, 05 Mar 2010 05:06:01


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.
 
 
 

excel not updating text boxes

Post by R2FyeScncy » Fri, 05 Mar 2010 05:35:03

Try running this macro:

Sub UpdateIt()
Application.CalculateFullRebuild
End Sub

--
Gary''s Student - gsnu201001

 
 
 

excel not updating text boxes

Post by bGJiZXVybW » Fri, 05 Mar 2010 06:03:01

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