Have spent considerable time trying to fix below. Need some help when the event is run, all text boxes are updated on the form.
Product1, Product2 etc all update correctly, so does kg1 - the rest (kg2, kg3 etc) won't update at all.
Private Sub CommandButton42_Click()
Dim ws As Worksheet
Set...