Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 Looks fine to me. But, the stupid box don't disply the right amount. I live in Europe and the Regional settings are a dot ( . ) for the thousands seporator and a comma ( , ) for the decimal seporator. When I enter 2250,00 ( or 2250 ) in .tbAmount, then textbox .tbVat displays : 427.5 which is not what I want as I hope to see : 427,50 When I bring these values over to the worksheet it displays : ? 2250,00 which is OK, and ? 4275,00 which is not OK, as I want to see: ? 427,50 Apparantly there is some error in the way the textboxes work with thousands. What is wrong with me ???? ( assuming I am not perfect ) I can't see what I did wrong. Mark. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
working with textboxes-VBA | New Users to Excel | |||
Textboxes | Excel Discussion (Misc queries) | |||
UserForm TextBoxes | Excel Discussion (Misc queries) | |||
tab between several textboxes | Excel Worksheet Functions | |||
Userfrom textboxes | Excel Programming |