UserForm in Excel 2013 Discount Textbox -
i have problem because want compute discount 2 textbox
display on 3rd textbox
.
1. txtprice 2. txtdiscount 3. txttotal
but don't know how put txtprice * .txtdiscount
(eg 100 * .10) computing discount.
i'm using code :
private sub txtdiscount_change() if txtprice.value = "" exit sub if txtdiscount.value = "" exit sub txttotal.value = cdbl(txtprice.value) * cdbl(txtdiscount.value) end sub
made few changes on code , solves problem.
hope in future.
private sub txtdiscount_change() if txtprice.value = "" exit sub if txtdiscount.value = "" exit sub txttotal.value = (cdbl(txtprice.value)) - (cdbl(txtprice.value) * cdbl(txtdiscount.value))
end sub
Comments
Post a Comment