Userform Calculation

I have a basic userform where I want to calculate "hours worked" figures against 10 employees.

For each employee a calculation works out the total cost based upon an "hourly" rate in an adjacent text box. i.e. text box1 = hours worked, text box 2 = hourly rate and textbox 3 = calculation. This work fines with each employee.

The problem comes with the sum box at the end, I basically want to add textbox 3,6,9,12, and 15 (the costs for each employee) into textboxWAGESCOST.

The calculation in the text box only works when i enter something into textboxWAGESCOST, but I want the total to count up/update as I go along?!

My code is below....can anyone help please?

Please Login or Register  to view this content.

Thanks for the reply, but i'm not really sure what you mean?

One way is to ceate a sub routine like this

Please Login or Register  to view this content.

then call up this routine under each boxes(3,6, 9, 12) e.i like this

Please Login or Register  to view this content.

of course you are going to delete the code for sum box TextBoxWAGESCOST

Please Login or Register  to view this content.

Thanks for the response, I've tried changing the code but i'm getting a mis-match error.

I've attached an example workbook as I might be missing something huge?

Thanks so much for your help

Thank you so much!

Hi -

Type something on the left textbox then back space, the values in right textbox will remains, same thing with the total textbox.
This is due to the exit sub.
Just for fun, try this approach

Regards,
Event