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

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -