First, I'm not sure I'm in the correct group or section - so if I need to repost, I certainly will. I'm using the following formula in cell B14217: =subtotal(103,a2:a15000). So far so good. I apply the filter and start making selections off of various columns and such, checking the value in B14217, returned each time. Again, so far so good. My next step was to insert a Userform and put in a textbox where the control source is: =sheetname!b14217

So far so good. I repeat my steps of changing the filter selections to so see that value in the Textbox is changing. After about 3 or 4 attempts, I notice that the number shown is no longer changing. It is remaining a hard-coded value. I check the cell value and it's no longer a formula but a value, which explains why my number stopped changing...but can someone advise me on why it is switching from a formula to a value, on it's own - so it appears?

Is there a setting in Options that would cause this? Seems like something simple, but so far I'm over looking a solution. Thoughts and suggestions?