When I wrinte this worksheet function in a spreadsheet:

= MOD ( -11993.4 , 29.53058867 )

....I get 25.55 - which is what I want...

....but if I do the same in VBA:

MsgBox -11993.4 Mod 29.53058867

....I get -23 !!!


How come MOD provides different answers, depending on if you're using it
in a spreadsheet or in a VBA-code???

How to make the VBA-code provide the result, that I want?


TIA,

CE