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