If I have 3 text boxes on a userform
1 is Price
1 is Qty
1 is Total
How do I get the Total text box to display the qty*price result
Right now I do this, but it isn't working
x = format(TxtPrice,"Currency")
y = format(TxtQty,"#,###)
z = format(TxtTotal,"Currency")
But my error displays as type mismatch, I am probably not even close on how to accomplish this.
I would appreciate any help, thanks for your time
Josh
Bookmarks