Question:
How can I change a unit or a value set at run time?
Solution:
To do so, you must use the following Formula method (via scripts):
object.SetValueData bstrValueName, bstrTemplateName, bstrData
This method updates the template (for example, “Field 1“) of a certain value set (for example, “Value 1″) with a certain value (for example, “10“), where the object is the module containing the set.
Example: Application.GetObject(“Formula1”).SetValueData “Value 1”, “Field 1”, “10”