Sum three textboxes %age in one textbox on userform

Hi,

I have some textboxes on a form and I'm trying to sum them and put the total in another textbox on the same form.

e.g=

TextBox10=100%
TextBox12=100%
TextBox14=100%

TextBox49=TextBox10+TextBox12+TextBox14

TextBox49=300%

Regards,

Xlhelp7

Good morning xlhelp7

How about :

Please Login or Register  to view this content.

HTH

DominicB

Hi DominicB,

Thanks for the reply!

I tried your code but it is not working.

Please find the attached sample file.

Thanks,

Xlhelp7

Hi xlhelp7

You were trying to link the code to the textbox14 change event, but textbox14's not going to be changed. Also you will need to set textboxes 10, 12 and 14 a default value of zero.

Then use this code :

Please Login or Register  to view this content.

HTH

DominicB

Hi dominicb,

Thanks for your help!

Now its working!

Regards,

Xlhelp7