LoadFormulaValues

<< Click to Display Table of Contents >>

 

LoadFormulaValues

LoadFormulaValues(FormulaName, UnitName, ValueName)

This method automatically loads a Value Set to a destination Unit, displaying a dialog box that allows users to inform different values from the ones defined on a Formula. This method contains the FormulaName parameter, which determines the name of a Formula, UnitName, which determines the name of a Unit, and ValueName, which determines the name of a Value Set.

A message box is displayed and allows users to inform values different than the ones defined for each Formula values.

 

NOTE

This method returns a logical value, that is, returns True if successful and False on failure, which does not mean a script error.

 

Example:

Sub Button1_Click()
  Application.LoadFormulaValues "Formula1",
    "Unit1", "Value1"
End Sub

Was this page useful?