Declaring a simple function

[mtheriault2000]

Hello

First time that i want to declare a simple function and no success.

I want B_Body to be a function, so i can use it in other calculation. So each time i need the B_Body value, program will call the calculation

Public B_Body, B_OPen, B_Close as variant
 
Function B_Body() 
   B_Body = B_Open - B_Close
End Function

Martin

 

[Richard Schollar]

VBA isn't like certain other programming languages (C for example) so there's no need to declare your function in addition to providing the function definition - you just need the function body. So you just need code in your module like:

Public B_OPen, B_Close
 
Function B_Body() 
   B_Body = B_Open - B_Close
End Function

where B_Open and B_Close are global variant variables.

 

[mtheriault2000]

Reresolve) Declaring a simple function

Thank you Richard.

Solution: Don't declare the B_Body as a variant.

Resolve

Martin