Hi
Please help me
I have userfom with textboxes and calculation between them.
After that I formated textbox value without demicals (textbox1=format(textbox1.value,"#") and I got value as ex. 1445 (real 1445,234)
Everything works perfect until I use userform from another computer. Calculation is perfect but format doesnt work,
value of textbox1 become 1445234 without comma. Why this happen?
Thank You
Your code is formatting whatever is already in textbox1 instead of formatting the source data. How does this data get into textbox1 to start with?
Also, the other computer may be using U.S. default formatting, which will ignore the comma when it reformats it to "#".
I suggest you attach your file and explain how to reproduce the situation you described.
Hi 6StringJazzer, thanks for Yours reply
Data in textbox1 goes from calculation and after that I am tryng to formart this textbox. I tried "#", "0" both same result.
My file exceed limit of size, here is code how I am doing this:
Now I am tryng to resize my file, and I ll attach it
Please Login or Register to view this content.
Here it is
Still help needed. Can find solution why format doesnt work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks