GetFormulaValueDataObj(FormulaName)

This method retrieves all settings from existing values of a certain Formula. Values are a data set saved in a Formula. This method contains the FormulaName parameter, which informs Formula's name.

Use this method to get a collection of values of a Formula. This method returns True if this operation is successful or False otherwise. The next code contains a usage example of this method.

Sub Button1_Click()
  Dim val
  ' When clicking the button, displays a message box
  ' with the number of Sets
  ' and the name of the First Set.
  Set obj = Application.GetFormulaValueDataObj("Formula1")
  MsgBox CStr(Obj.Count)
  MsgBox CStr(obj.Name(1))
End Sub