Hi everyone, Good Morning
Using examples from this outstanding forum I have developed a userform that almost does everything I need. The problem is when I update the monthly values the userform overwrites the sum formula in the worksheet (QTR totals). I want to manipulate the monthly values to keep within my quarterly budget.
Is there a way to just view the total cell and not have the userform overwrite it?
I have tried converting the monthly cells to numbers and summing them up but could not get the result to display on the form. Researching the problem, controlsource properties and mode are mentioned but being a VBA newbee I need examples to play with to understand.
I have attached my worksheet.
Any guidance and suggestions will be greatly appreciated
Thanks for your time and effort
Bookmarks