Stucked beween Decimal point and common issue in Microsoft Excel

[Aza]

If I use a VBA form to fill out data which sometimes have a decimal separator, in Europe the comma is used as a decimal sign. However when I use a comma the value is interpreted as a text when the macro places the value in the spreadsheet. Only when I use the decimal point in the VBA form, the value is accepted as a value in the spreadsheet. Does this have to do anything with the MS Window settings or is it releated to my english Excel version. How can I prevent this problem without going into VBA code to tackle it.

[Shurod]

You are trying to use European data in a UScentric workbook. Excel looks at your Windows settings. So there are 3 ways to avoid this (1) To get your European counterparts to work in US style (unlikely), (2) To change your settings when you absolutely have to use their data in their local format, (3) You can get VBA to make the adjustments for you.

[Erakna]

The strange thing is that I am working with a Dutch Windows version set to the European settings? However I use the English version of Office. In the spreadsheet it works fine, but the VBA code seems to be based on US standards?? Is there a way to change this setting? Moreover I have currently installed the Dutch Office version and the problems remain. So typing eg. 2,5 in a VBA form results in 2.5 in the spreadsheet cell, which is interpreted as a text.

[Bontu]

I find that suggestion 2 (change your settings) is the easiest way to workaround with. After all, the change only has to be temporary.