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
|