Page History

...

Description

Excerpt
Sets the formula of the worksheet to the given Add-In Formula.

Signature

	C#
	C#

public void SetAddInFormula(string formula)
{signature}
{signature:

}

Signature

	vb.net


	vb.net

Public Sub SetAddInFormula(ByVal formula As String)
{signature}

{parameters}
{param:formula}

Parameters

Param

	formula
	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#}

Remarks

Example

Code Block

	csharp
	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:

Code Block

	vb.net

|title=


	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}

Scrollbar

Space Shortcuts

Page tree

Versions Compared

Old Version 5

New Version Current

Key