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

[funkymonkUK]

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

 

[Leith Ross]

Hello FunyMonkUK,

If you have disabled the TextBox by setting the Enable Property to
False, this will bugger it up. To prevent the user from changing the
contents set the Locked Property to False. Everything else seems fine.

Hope this helps,
Leith Ross

 

[funkymonkUK]

thanks i made sure however it is still not working
i will post my code now

 

[funkymonkUK]

This is how i linked the cells

Private Sub CJHours_Change()
' CJHOURS value
Range("v2").Value = CJHours.Value



End Sub



Private Sub DJHours_Change()
' DJHOURS value
Range("v3").Value = DJHours.Value
End Sub

Private Sub HCHours_Change()
' HCHOURS Value
Range("v4").Value = HCHours.Value
End Sub

Private Sub THours_Change()
' THours Value
Range("v5").Value = THours.Value
End Sub
Private Sub MHours_Change()
' Mags Hours value
Range("v6").Value = MHours.Value
End Sub

Private Sub Chours_Change()
' C Hours Value
Range("v7").Value = Chours.Value
End Sub
Private Sub OHours_Change()
' Other Hours Value
Range("v8").Value = OHours.Value
End Sub
Private Sub Total_Change()
' Other Hours Value
Range("v10").Value = Total.Value
End Sub