Discounted Price Calculation With Vba Class Module
On the userform,the price of the product and discounted price is calculated as automatically with text boxes.Vba class was used for calculation.
Following formula is used to calculate the discount :
"Discounted Price = Quantity * Price (Quantity * Price /100) * Discount "
If you wish calculations and processes can be saved from the userform to sheet.