I have two boxes in a user form (both are text boxs)
The first box is the qty box (output to D12)
The second is the price box (output to F12)
I multiply the qty by the price to get the price
They write the values to cells D12 and F12
If I go to enter a price in the user form it kicks me to the debug window
If i enter a qty then a value the spreadsheet updates correctly
if I change the price the spreadsheet updates correctly
But if I change the quantity the price does not change
Any ideas
Thanks
Private Sub TextBox89_Change()
Worksheets("PrintOut").Range("F12").NumberFormat = "$ 0.00"
Worksheets("PrintOut").Range("F12") = TextBox89.Value * TextBox85.Value
End Sub
Private Sub TextBox85_Change()
Worksheets("PrintOut").Range("D12") = TextBox85.Value
End Sub
Bookmarks