Have Geek Brain

VSTO: how to update formula when cell value changes

Let's say I have a formula = MyCustomFunction (D2) where MyCustomFunction is written to Excel AddIn using C #

How can I reasonably tell my formula to rerun when cell D2 changes?

+1


a source to share


1 answer


If the performance penalty is not too great, i.e. the spreadsheet isn't huge for a lot of calculations, can you just set Application.Volatile=True

to your function?



+1


a source






More articles:


All Articles