Calculating with textboxes....
Mark Rosenkrantz wrote:
Dear all;
I have a UserForm with a few textboxes.
The first textbox : tbAmount holds an invoice amount.
The second textbox: tbVAT should display the amount of VAT ( 19 %
of the amount )
The formula I use is: .tbVAT.Value = .tbAmount.Value * 0.19
Try:
..tbVAT.Value = FormatNumber(.tbAmount.Value * 0.19,2)
--
Steve Garman
|