I can not get this code to work, I am getting an ambiguos error I do need all 3 message boxes to come up at the same time if the < value is met. Thanks any help is appreciated
Private Sub Worksheet_Calculate()
If Range("F10").Value < 5300 Then
MsgBox "Initial Load Must be at least 5,300Kgs"
End If
End Sub
Private Sub Worksheet_Calculate()
If Range("G10").Value < 4300 Then
MsgBox "Initial Load Must be at least 4,300Kgs"
End If
End Sub
Private Sub Worksheet_Calculate()
If Range("H10").Value < 1300 Then
MsgBox "Initial Load Must be at least 1,300Kgs"
End If
End Sub