I have run into a problem. I have a userform which has several textboxes which currently display figures from a worksheet cell with a formula in it. Unfortunately, the formula is automatically replaced by the value in the textbox which defeats the purpose. What I want to do is have the textbox display a value based on a formula which references the active workbook.

I am a newbie so detailed code is appreciated. Additionally, I have 3 years worth of textboxes with 36 rows in each year. If there is anyway to do one set of code for each year as opposed to code for each textbox that would be helpfu

Thanks.