Userform with 5 textbox and 1 needs to refresh to have total
 

hey

I have 5 text boxes which 1 of them has to be a running total of what has
been entered in. what I tried linking the 5 textboxs to a cell and then for
the one that i want to have the total in i have made its value = cell however
this does not seem to update. any ideas? i dont want the user to input this
textbox so i disabled it will that make a difference??

Any help will be appreicated

Userform with 5 textbox and 1 needs to refresh to have total
 

Try in your userform code:

Private Sub TextBox1_Change()
Me.TextBox5 = Val(Me.TextBox1) + Val(Me.TextBox2)+Val(Me.TextBox3) +
Val(Me.TextBox3)
End Sub

Repete this for each textbox 2-4

Then, to prevent the user from accessing Textbox5, don't Disable it.
Instead, in the userform design mode, Rt click the textbox
PropertiesLocked=True

"VBAfunkymonk" wrote:

hey

I have 5 text boxes which 1 of them has to be a running total of what has
been entered in. what I tried linking the 5 textboxs to a cell and then for
the one that i want to have the total in i have made its value = cell however
this does not seem to update. any ideas? i dont want the user to input this
textbox so i disabled it will that make a difference??

Any help will be appreicated

Userform with 5 textbox and 1 needs to refresh to have total
 

Why not use the change event of each of the 4 textboxes to calculate the sum
and put that in textbox 5?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"VBAfunkymonk" wrote in message
...
hey

I have 5 text boxes which 1 of them has to be a running total of what has
been entered in. what I tried linking the 5 textboxs to a cell and then
for
the one that i want to have the total in i have made its value = cell
however
this does not seem to update. any ideas? i dont want the user to input
this
textbox so i disabled it will that make a difference??

Any help will be appreicated