You're welcome.

The syntax used in VBA is much more like most other languages - I
found the syntax in worksheet functions to be odd when first using XL.

Pete

On Jan 11, 4:35*pm, DTTODGG wrote:
Yes, this helps greatly. Why can't everything be the same syntax-wise? I
guess that's what makes this so much fun!
Thank you.



"Pete_UK" wrote:
Mod in VBA is not the same as the worksheet function MOD. You need to
look in VBA Help (rather than Excel Help) to get the syntax. Other
functions which likewise have a different syntax include And and Or.

Hope this helps.

Pete

On Jan 11, 3:49 pm, DTTODGG wrote:
Gary, thank you for the prompt reply on my first question it works
wonderfully, unfortunately, I don't understand how.

Also, do you know an answer to my timing question or should I post that
separately?

I don't understand the function syntax.
If the MOD function help, it shows MOD(number,divisor)
How does SCounts Mod 8 work and how would I know this syntax?

Thank you.

"Gary''s Student" wrote:
Function OL(SCounts As Integer) As Integer
OL = 8 - SCcounts Mod 8
End Function

and in the worksheet used like =OL(64) which returns 8
--
Gary''s Student - gsnu200764

"DTTODGG" wrote:

Hello,

I'm trying to make 2 functions. These will be my first homemade functions,
so please be specific when helping me :-)

First, in Module1 I tried:

Function OL(SCounts)
* *OL=8-MOD(SCounts,8)
End Function

This gave me errors. Can you nest a function "MOD" within a custom function?
It worked ok when I left out the MOD function (OL=8-2).

-----------------------------
Second, is there an already made function to convert text to mm:ss..hh?

I'm trying to work with stopwatch times (minutes, seconds, hundredths).. I
need to be able to add, subtract, average, etc...

Thank you so much for sharing your wisdom.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -