Label caption

[puuts]

Hello, could you me help on this.

I have a userform and 4 textboxes on it and i just want to display the sum/result in Label2 and not in a textbox(I want it in a label). Is it possible?

Ex:
textbox1: 5
textbox2: 5
textbox3: 5
textbox4: 5
Label2: 20

[john55]

instead to capture it in textbox maybe something like this

Please Login or Register  to view this content.

[puuts]

Hi john, thanks for reply, but i can't get what you've provided

[john55]

assuming your result is somewhere in col A you can use...

Please Login or Register  to view this content.

[puuts]

all the result was in the userform

label2.caption = textbox1.value+textbox2.value...? i tried that but it's not working.

[john55]

maybe this...

Please Login or Register  to view this content.

[puuts]

Hi john, still not I've attached the sample.
sum of the 4 textboxes should be display in label2.

[john55]

yr file is empty, anyway try this in yr file

Please Login or Register  to view this content.

[puuts]

Hi John, still not displaying result in Label2

[JosephP]

Please Login or Register  to view this content.

not much benefit in doing it in the initialize event if the textboxes are empty ;-)

[john55]

hi JosephP,
Thank you very much for your obs.! I tested on a file with values without takeing into account the empty textboxes!
ok, I'm "on error", so I'm going to bed! LoL

[JosephP]

:-)
that line is a reminder to me because I tend to code into the early morning which is not always very productive!

[john55]

JosephP, hope you did not mind...it was just a joke!

[JosephP]

no I didn't mind at all-that's why I started the reply with :-)

[puuts]

Hi John and Joseph!, thank you so much! It's working now! Perfect! Thanks again!