Updating multiple cells from a UDF

[Terry]

Is there any workaround for updating multiple cells from a UDF using the
excel events to hook up another procedure after the UDF has returned it's
value ?

Rdgs,

Terry

 

[Harald Staff]

Hi Terry

You might play around with the Calculate event and call a macro or a
function from there. But you won't have much control over the order of
calculations, I think, so "after the UDF has returned it's value" would
probably be hard to ensure. It may be safer so call a sub or a VBA function
from a Change event, where you start the code with "calculate". Assuming
that you know which input that trigs your changes, that is.

 

[Charles Williams]

Hi Terry,

Have you considered using an array formula UDF so that it returns an array
of results to multiple cells?

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm