rounding in a user-defined function

[Rainer]

Hi,

how can I round a value in a user-defined function

Rainer

[Villeroy]

In a spreadsheet?
=ROUND(myFunction(args);2)

[Rainer]

Hi Villeory,

I know how to round in a spreadsheet itself, but how do I in a user-defined function?

e.g.

Function Test as Single
Dim value as Single

value = 2 / 3
Test = ROUND(value,1)
End Function

The examples doesn't work?


Rainer

[Villeroy]

Do yourself a favour and let it happen on the sheet if possible. Search this forum as well as oooforum.org for keywords "FunctionAccess" and "callFunction". Service "FunctionAccess" includes a lot of pitfalls if you are not familiar with this beast of an API.