View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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