Excel does not recalculate when calling VBScript

[thetinman]

I have an Excel spread sheet that calls a user defined function. First it calls a Visual Basic Script by inputting "=my_function(1,2,3)" into a cell. This script then calls a DLL. When I initially call the function, it returns a value. When I go back and edit the input values in the function, the value returned value is not recalculated. Is there something I can do that will cause the function to return a new value when the input parameters are changed?

[VBA Noob]

Read links first

http://www.decisionmodels.com/calcsecretsj.htm

http://www.decisionmodels.com/calcsecretsh.htm

Please Login or Register  to view this content.

can work but it recalc's all the time so may slow your spreadsheet down. Look at tips on second link to recalc the cells

HTH

VBA Noob

[thetinman]

Thanks, but I'm still a little confused. Pressing F9 or CTRL-ALT-F9 does not result in a recalculation. The script I'm using resembles the following, but with more input variables

Please Login or Register  to view this content.

The statement

Please Login or Register  to view this content.

might be useful, but I don't know how to insert it into my script.