Add number of text boxes inside a UserForm

[MariaPap]

Hello

I have a UserForm(UserForm5) that create some calulations depanted of what user choosed.

I use this code for the calculation and works creat.

Please Login or Register  to view this content.

When i try to add the results of some textboxes i get as result only the number of the first textbox.

Please Login or Register  to view this content.

Any idea for this?

Thnks in advance for any assistance!

[millz]

This may seem a little long, but prevents errors.

Please Login or Register  to view this content.

The reason why your code wasn't adding up is because textbox17's value is being formatted as text after the first line.

[Andy Pope]

The problem is textbox property Value is a string variable and + is a valid string operation performing concatention

So if you enter the values 14, 16 and 26 into the 3 textboxes this is how it is processed

Please Login or Register  to view this content.

And not 56.

You need to convert the contents into numeric values first, probably use a function so you can handle empty or non numeric content.

[MariaPap]

Thank you very much both of you.

millz

Unfortunately this does not works as you can see in the video attachment.

Andy

Yes as i see this is the problem. As you probably noticed(in my sample workbook) to get the values in TextBoxes 16 & 19 from sheet "Spairs" i use this pice of code.

Please Login or Register  to view this content.

So any idea of how can i solve this issue?

http://screencast.com/t/a1v7t6m8rGl

[xlbiznes]

Hi,

Just do this :

Please Login or Register  to view this content.

[MariaPap]

Thank you xlbiznes.

This works for the quantities text box but not for the values sum.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This does not works.

Any idea?

[xlbiznes]

Hi,

try this now :

Please Login or Register  to view this content.

[MariaPap]

Yes. That's it. Works Great. Thank you for that!

Now i am hoping that i'll be able to use it in my original workbook that is exactly the same as my sample but has 20 lines of textboxes!!

[xlbiznes]

You are welcome, Glad i could help