how to add values in textboxes in user forms

[Bridger18]

Hi Everyone
I am stomped by what seems like a simple problem, how to add the value in 2 textboxes and put it into a third one.
This is my code for a command button, it gets values from the last row of a worksheet, I then want my form to display these, which it does, and then add them in pairs and place the result of addition into a third box for each pair. Instead it concatenates the values

[Greg M]

Hi there,

I haven't tested this, but the following approach might be worth a try:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[Bridger18]

Thank you, That worked perfectly. Could you explain why that is needed?

[Greg M]

Hi again,

Thanks for your feedback.

Could you explain why that is needed?

Values taken from a TextBox control are always treated as String values (regardless of what they might "look like", e.g. 123.45), and when you try to "add" string values with the "+" operator the effect is to concatenate the two string values.

Using the CDbl function converts the string values to Double values which may then be added arithmetically.

Regards,

Greg M

[Bridger18]

Thank you again, that is so clear now, You are a true Expert!

[Greg M]

Stop it, stop it . . . you're making me blush!

As before, you're very welcome - I'm glad that I was able to help.

Regards,

Greg M