Updating multiple cells from a UDF
 

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

Updating multiple cells from a UDF
 

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.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Terry" skrev i melding
...
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

Updating multiple cells from a UDF
 

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

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.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Terry" skrev i melding
...
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