Argument is not Optional (open office basic macro)?

Question

can you help me work out whats wrong in this function? Function TrueSolarTime(eqtime As Double, longitude As Double, _     timeZone As Double, hours As Double, minutes As Double) As Double   dim time_offset as double   dim x as double     time_offset = eqtime - (4 * longitude) + (60 * timeZone)     TrueSolarTime = hours * 60 + minutes + time_offset   End Function

Answer 1

The error Argument is not Optional indicates that you are not passing the correct number of parameters to your function. In the above function you need to give it 5 parameters: eqTime, longitude,timeZone,hours and minutes. A correct call to your code would look like this:

dim result = TrueSolarTime(1,2,3,4,5)

Wherever you are calling TrueSolarTime make sure that there are 5 numbers being passed in to the call.

Additionally there is an extra line in your function that is not needed. You can remove the line:

dim x as double

as the x variable is never used.