Page History

{description}
{excerpt}
Sets the formula of the worksheet to the given Add-In Formula.
{excerpt}
{signature:C#}
public void SetAddInFormula(string formula)
{signature}
{signature:vb.net}
Public Sub SetAddInFormula(ByVal formula As String)
{signature}

{parameters}
{param:formula}
Add-In Formula you wish to add, as a String.  Include the equals sign as well as a reference to the Excel Add-In file you wish to reference, if the file is not included in the local macros directory.
{param}
{remarks}

{remarks}
{example}
{code:csharp|title=C#}
//--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple
//--- from the file TestAddInFormula2Helper.xpl.xla
WB[0]["D3"].SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)");
{code}
{code:vb.net|title=vb.net}
'--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple
'--- from the file TestAddInFormula2Helper.xpl.xla
WB(0)("D3").SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)")
{code}

{example}
{scrollbar}