Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform with 5 textbox and 1 needs to refresh to have total | Excel Discussion (Misc queries) | |||
Userform with 5 textbox and 1 needs to refresh to have total | Excel Programming | |||
userform textbox | Excel Worksheet Functions | |||
Textbox in userform | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |