View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve Garman Steve Garman is offline
external usenet poster
 
Posts: 107
Default 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