Make code available as a function

[bris]

Hi

Is there a way to add the macro code so it will be available as a "normal"
function in excel??

Br.
Brian

 

[Frank Kabel]

Hi Brian
something like
public function foo()
foo = "some value"
end function

enter =FOO() in a cell in your workbook

 

[BrianB]

Instead of Sub ...() use Function :-

'------------------------------------------
Function MyFunction(arguments separated by commas)
'- your code here
'- return value same name as function
MyFunction = x
End Function
'-------------------------------------------

in worksheet use =MyFunction(with arguments).
eg.

'-----------------------------------
Function MyAddition(a,b)
Myaddition = a + b
End Function
'-----------------------------------

 

[bris]

Yes thanks. Just the functionally I was looking for!
Thanx

Brian

 

[Tom Ogilvy]

Make sure you put your code in a general/standard module (in the vbe, Insert
=> Module) rather than a sheet or the thisworkbook module.