Formulas and vbs

[Jeffm]

Hello all. Here's my issue, I have a form and a spread sheet in the spead sheet I have 3 fields that add a row =sum(aa5:aa25) and one =sum(bb5:bb25) then i divide those totals. In my for I need to have the totals of those ranges show. When I start the form it deletes those formulas evey time no matter what i do. How do I keep those so they will display the totals as they change in the form without them deleting each time?? Any help or ideas would be great.
thanks in advance.

 

[Jim North]

Is it possible you are stepping on your own tail? Is there code that is clearing those cell locations?

 

[Jeffm]

I did check all the fields and the vb to make sure it wasnt clearing those field. Im hitting my head on the desk trying to get this to work. I insert the formula in excel as soon as i start the input form and change a value within the form it deletes all the content or formulas in those two col/rows ??

 

[Jim North]

Can you copy and paste the code in your user form for us to take a peek at??