Sunday, January 10, 2016

Excel Discount Calculation On Userform With Vba Class

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.