Issue with European Versions and VBA

[Bill]

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

 

[Tom Ogilvy]

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.