NickAtNight
New Member
- Joined
- Sep 16, 2017
- Messages
- 16
How do I build a formula from a string?
Lets say I have 10 user defined functions... (sam, fred, mary,...)
and I want to build the formula in the spreadsheet.
I can use a data validated cell to limit the function to the list of UDF's.
Then I want to create the formula as a string.
'=sam(v1,v2,v3)' or '=fred(v1,v2,v3)'
Then apply the string as a function.
Lets say I have 10 user defined functions... (sam, fred, mary,...)
and I want to build the formula in the spreadsheet.
I can use a data validated cell to limit the function to the list of UDF's.
Then I want to create the formula as a string.
'=sam(v1,v2,v3)' or '=fred(v1,v2,v3)'
Then apply the string as a function.