• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

USERFORM TO SUM AND INSERT

I am new in userforms
i have made a userform that has 8 boxes with numbers and another that sum that boxes and the result place it to a cell (L2)
the wrong is that some numbers are decimels for example 0.33 but in greece we use 0,33
that userform can't calculate right the values with decimels
surely i have written something wrong but i don't know what
 

Attachments

  • TEST2.xlsm
    25.5 KB · Views: 2
Hi,
In your code replace comma by dot
Code:
TextBox11.Value = Replace(TextBox11.Value, ",", ".")
See working example
 

Attachments

  • TEST2.xlsm
    24.3 KB · Views: 8
thank you for your try and i am sorry that i was late to respond and test your solution. it's ok with a small adjustment because for a reason it didn't bring the result inot the cell L2 but now is ok.
 
Back
Top