Dear Expert,
Below mentioned code is on a User form Text box Named as Qty:
In the Below Code:-
Qty, C_LL, UOM_MM are a Text Boxes contains some value given by a user.
F_Qty is a another textbox, based below logic I would want a Result. But when I execute the same. Getting an subjected Error, Kindly help me to amend the code which gives desired result!
Thanks & Regards,![]()
Private Sub Qty_AfterUpdate() If C_LL > 0 And UOM_MM = "M" Then F_Qty.Value = Round((C_LL.Value * Qty.Value) / 1000, 0) Else F_Qty.Value = Qty.Value * 1 End If End Sub
Rajeshkumar R
Bookmarks