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

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