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


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=345881

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

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=345881

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

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


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=345881

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

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


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=345881