Calculate with Decimal in UserForm (Texbox1 = Textbox2 + Texbox3)

[johan12]

HI all, I'm new in Excel VBA,

I have one userform to calculate example : (Texbox1 = Textbox2 + Texbox3) (In texbox1 is Rezultat, Need to Calculate Texbox2 + Texboxt3) with Decimales... Example if I want to calculate example 0.50 + 1 hi type rezultat only 1 Not 1.5 (1.50) Or if I type 2.5 (2.50) Hi Calculate only 2 not 2.50,
Example if Texbox2 is 0.50 and Texbox3 is 2, after Calculate Texbox2 + Texbox3 Resultats is again only 2, not 2.50 (2,50)


So Plz See me Example Form in atachments and regulating the problem for me because i am very new to Excel/VBA.

Thank You.

[Pulsus]

johan12,

Try this code in your butonn:

Please Login or Register  to view this content.

[royUK]

A TextBox is by default a String so you need to convert to a Numeric value, e.g.

Please Login or Register  to view this content.

[johan12]

I try, but nothing Again not work... any idea.... thanks...

[Pulsus]

johan12,

What hapenned when you use my code?

[johan12]

johan12,

What hapenned when you use my code?

When use your code Rezultat is example : IF 5.50 + 1 = 7, not 6.50 , Or if 0.50 + 1 = Rezultat is = 2, Not 1.5

[Pulsus]

Johan12,

Sorry, as I am not a native english speaker I understand that you want the opposite, try this code:

Please Login or Register  to view this content.

[johan12]

Pulsus,

Thanks a LOT , this code Working Prefect... THANKS again...

[Pulsus]

Johan12,

Good to know. You are welcome.