Calculate Inventory and number of items sold

SOLVED see reply. I use a user form to fill in an invoice, the form consists of a drop down box for part numbers, a part description, labour price, retail price and qty sold
I get a runtime error 1004 Application-defined or object defined error when the ok button is pressed and the Txt Box Qty is empty
I use the attached code to fill in the invoice sheet from the user form when the ok button is clicked

Please Login or Register  to view this content.

SOLVED. I had to define the TbxQty as a number, when the TbxQty box was blank it was considered a null string not 0. new code is below

Please Login or Register  to view this content.