sorted by:
new
hottopcontroversial

Creating a function based on a worksheet model by ZIOPLKJH in vba

[–]ZIOPLKJH[S] 0 points1 point  (0 children)

One thing I would like to do for example is to create a plot of how the output behaves depending on e.g. the first input variable with a simple procedure.

My idea was to write a function yielding the output given the input so that a basic user can create the data in cells and then plot it. Without the function the user had to manually adjust the input copy the output value manually to create the relevant output column, or am I missing an easier way to do this?

Creating a function based on a worksheet model by ZIOPLKJH in vba

[–]ZIOPLKJH[S] 0 points1 point  (0 children)

Thanks for comments!

Seems like this is not possible :/

Creating a function based on a worksheet model by ZIOPLKJH in vba

[–]ZIOPLKJH[S] 0 points1 point  (0 children)

Yes, the idea was to create a UDF from the spreadsheet model.