Integration between VB and Excel

[Kreller]

While attempting to build a dynamic activity calender I have given up o
the "basic" fomulas in Excel because it is only possible to embed up t
seven fomulas in one (i.e. I have embedded seven "If...then" formula
into one big motherf...). This big fomula is called in an "overview
calender and refers to data in another spreadsheet containing
detailed calender, and my problem is that I want to be able to proces
more than the possible 7-in-1 formula and I figure that the way to d
that is to make a loop in VBA. Is it possible to integrate a loop i
excel without making it as an "update" macro? So that when I plot dat
in the "data" spreadsheet it shows in the general calender without m
having to press update?

 

[Tom Ogilvy]

http://www.cpearson.com/excel/nested.htm

for your specific question, you can create a user defined function that can
be used in a worksheet like a built in function. If you represent your
dependencies in the function arguments, it will be calculated as appropriate
like built in functions.