Updating multiple cells from a UDF

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
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.
 
Back
Top