Using own VBA functions in formulas

[ricola]

I am used to write custom VBA functions in Excel and use them in Excel worksheets just like the built in Excel functions.

Now I tried the same in BO: using VBA functions in expressions in the formula editor. But my own VBA functions won't appear in the function list of the formula editor and are not recognized by the system.

Am I missing something here or doesn't BO offer this concept at all.

 

[TheVMan]

You can write your own variables and insert them into cells in BO with the BO variable editor. You just right click on the cell you wish to have a formula in and select variables. You can then add a variable to the cell. Any visual basic scripting happens behind the scenes in Macros.

V