Command Button and Sum Text Box

[esaban]

have a problem making my userform more efficient.

I have 3 textboxes. 1 and 2 sum values from 8 other textboxes and textbox 3 calculates a %score from the values in box 1 and 2. Essentially what I want to do is have 1 command button sum the values for box 1, 2, and also the %score for box 3. instead of having 3 command buttons to calcuate box 1, another for box 2, and then another for box 3

[ag273n]

you could use something like this:

Please Login or Register  to view this content.

in the code above, when the commandbutton1 is clicked, the value of textbox4 is taken from the sum of all other text boxes...

[esaban]

hey ag273n, thanks for the reply.

not sure if you saw the file, so let me try to explain better.

I want 1 command button to sum textbox values from 1-8 in text box 9, sum values textbox 10-17 in text box 18, then also calculate a % socre in textbox 19.