Comma decimal separator giving problems in a VBA Form

[wpryan]

Hi All, I developed a form in VBA that is expecting some numeric entry, and a command button makes some calculations. It is working fine on my computer, but on people who have operating systems that use a comma as a decimal separator, gives incorrect information (in fact, the calculation result always seems to be the number 2, no matter the entered data). The underlying worksheet correctly calculates anything when they use the comma separator, only in the VBA form is it giving problems.

Is there a solution or workaround for this?

 

[Micron]

Would have to see your code to have any idea, except to say you can test for regional settings property values and then code accordingly?
For Excel -
application.International(xlDecimalSeparator)

 

[RoryA]

You should most likely be using one of the C functions to coerce the text in the textbox into a number based on the user's regional settings - most likely CDbl or CLng