Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox in UserForm issue
I discovered a new bug in the project I'm working on...
I have my entire project working perfectly, except that it is used in Europe and South America as well. These countries use Windows XP but they go into Control Panel -- Region and Language Options and they set their Windows Region to (example) German. Then they open up my project, and the only difference is that the decimal is a comma instead of a period. This apparently throws off my Excel project if I save it in German and open it up after switching back to English (United States) settings. The problem is this: I have my TextBoxes set to display TextBox.Text as 2 decimal places (0.00). This works fine in English, and stores it as a number. It unfortunately doesn't recognize it as a number when I go from German to English though - When I open it in English, the 0,00 remains, and it is recognized as Text, not Numeric. Is there a way to force the spreadsheet or .Text value to recognize it as a number when it's storing the entry in the Textbox? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform textbox help | Excel Programming | |||
Textbox highlighting issue | Excel Programming | |||
TEXTBOX in USERFORM | Excel Programming | |||
textbox issue | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |