Sum only positive decimals

[Villalobos]

Hello,

I have some problem when I would like to sum only positive decimals on userform, I would like to separate the numbers with comma (",") and sum them, the format should be "0,0" and only numbers and "," can be given in textboxes. How should I do this?

Thanks in advance the reply!

[duncandhu]

Hi Villalobos,

I assume when you say decimals you mean integers (whole numers) - please correct me if you mean the part of the number after the decimal point.

This code will sum only the positive integers.

Please Login or Register  to view this content.

Thanks,
Duncan

[Villalobos]

hi,

I mean for instance:
if i entry in textbox1 1,2 and 2,6 in textbox2 then I would like to see in textbox3 3,8.

[Marc L]

Hi,

use CDbl function to convert each textbox value to number to sum them …

Regards !