Testing for variable state in VBA

[excelbobabc]

Can I use a IF statement or other tests on an Excel sheet to look at a variable in a VBA program running in the background?

Is this possible

=IF(some vba variable=100,SUM(B5:B15),"")

Or do I have to write the variable from VBA to a cell and then use that cell in the IF statement?

[Simon Lloyd]

You can create a udf to return a value look here http://www.thecodecage.com/udf.php

[rgi]

Yes, If the VBA is a user defined function (vs. a SUB) that can return a value. It would be the same as using any of the excel formulas (which are also functions)