Hi everyone
I have a product registration spreadsheet with the fields: ID, Product type, Product Amount, Price, Total
sales.PNG
This data is loaded into a form by a ListBox where I search for the category in a ComboBox and click on the button to filter only the products in the respective category.
form.PNG
Is there any way to enter a value in the TextBox "Sold Amount" and have it multiplied with the values in my ListBox "Amount, Price and Total"?
Multiplying .PNG
These multiplied registrations should be recorded in my sheet: "Sales" according to the example below:
salesregister.PNG
Attached I am forwarding the spreadsheet.
If anyone can help me, I will be very grateful.
Bookmarks