Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple hyplerlink updating | Excel Worksheet Functions | |||
Updating multiple graphs in multiple worksheets at the same time | Excel Discussion (Misc queries) | |||
Updating Multiple Spreadsheetssheets | New Users to Excel | |||
Updating links in multiple worksheets | Excel Discussion (Misc queries) | |||
updating multiple worksheets | Excel Discussion (Misc queries) |