Hi there
I have dabbled a bit with VBA in excel but im not an expert, I have designed a form with the following:
From, Destination, Product, Quantity, Carton Quantity, Costing road, Costing Air
I have been able to link the combobox's to the cells on the worksheet (data).
1. Need to calculate the amount from selected value on the Product (combobox) with the Quantity (textbox) required = Carton Quantity (textbox)
2 .From that I need to multiply the Carton Quantity to a cell range with a $ amount and the value to be returned to a Costing road (textbox).
3 I also need to search the selected value on the destination (combobox) to a corresponding value with in the worksheet and return its value to another Costing Air (Textbox).
Thank you in advance for your assistance.
I have done the calculation in a workbook/sheet but would like to have it as a form.
I have dabbled a bit with VBA in excel but im not an expert, I have designed a form with the following:
From, Destination, Product, Quantity, Carton Quantity, Costing road, Costing Air
I have been able to link the combobox's to the cells on the worksheet (data).
1. Need to calculate the amount from selected value on the Product (combobox) with the Quantity (textbox) required = Carton Quantity (textbox)
2 .From that I need to multiply the Carton Quantity to a cell range with a $ amount and the value to be returned to a Costing road (textbox).
3 I also need to search the selected value on the destination (combobox) to a corresponding value with in the worksheet and return its value to another Costing Air (Textbox).
Thank you in advance for your assistance.
I have done the calculation in a workbook/sheet but would like to have it as a form.
