Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with European Versions and VBA
Hello,
I have a small program that associates have been trying to use in Germany. Part of it is a text box where they enter a number (like 1.5, 20, etc.) The decimals don't work right. They have tried chaning their settings, etc. Any ideas? Thanks. Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with European Versions and VBA
I suspect they are entering 1,5 for 1.5. If so, you would need something
like Dim sStr as String Dim dblNum as Double sStr = Textbox1.Text dblNum = cDbl(sStr) cDbl will convert it to a double and will respect their regional settings. -- Regards, Tom Ogilvy "Bill" wrote in message hlink.net... Hello, I have a small program that associates have been trying to use in Germany. Part of it is a text box where they enter a number (like 1.5, 20, etc.) The decimals don't work right. They have tried chaning their settings, etc. Any ideas? Thanks. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Spreadsheet View Issue XP and 2003 versions | Excel Discussion (Misc queries) | |||
European Address Data | Excel Discussion (Misc queries) | |||
Please include fonts from previous versions ('98) in new versions | Excel Discussion (Misc queries) | |||
European date formats | Excel Worksheet Functions | |||
Enter european date | Excel Programming |