Log In
Register
Home
New Member
July 29, 2020
Offline
I have some spreadsheets that have a bunch of logic defined in the sheet. I want to convert this sheet to an addin and write some vba routines to create a "wrapper" for the spreadsheet. The wrapper functions that I will call from other spreadsheets will take the parameters passed in, update corresponding cells in the addin, update the calculations and then return a value back. There seems to be issues with sheet calculation in the addin - it won't calculate.
This is actually quite powerfull if it would work as you can encapsulate behaviour for an entire worksheet that is callable from a vba function in the addin. Pass the information in - run calculations, return any number of results through vba functions that get the values of specific calculated cells.
I am wondering is there are additional excel api calls that I need to be doing to enable calculation of worksheet cells in the addin?
November 8, 2013
Offline
Hi Kevin,
Hard to say without seeing how the functions are built.
For example, a function will not work if the function itself is supposed to change a value in a cell.
You can add Application.Volatile to your vba functions, if they are supposed to update at each recalculation.
Last, Application.CalculateFull should recalculate every open workbook, including addins.
1 Guest(s)
