comma vs. point

[travelkid]

I used the code below to make a change event. Unfroutunately it writes in the numbers into the excel sheet with a comma instead of a point. This makes it afterwards impossible to use this number for further calculations. I have used the exact same code in the same program earlier on, where it works absolutely fine.. I ve got no idea whats wrong here. I alredad tried the CDbl function, whcih is not working.. Thanks for the help.

Please Login or Register  to view this content.

[AliGW]

I'm no VBA expert, but T_01 does not appear to contain anything that needs changing. If the Replace statement at the top works, then add another for each variable.

Here's what this novice would try:

Please Login or Register  to view this content.

If it works, then adapt it for the other cases.

[travelkid]

Hello,

when I change the code to:

Please Login or Register  to view this content.

the numbers are written in with the point instead of comma, which is good. However I cannot anymore make my selection via the combobox. Means when I change T_02 from "Wasserstrom" to "Graustrom", then the values are not adapted...

Best, Matthias

[AliGW]

I think it's time to share the workbook.

[travelkid]

Well, I cant, its too big...

[AliGW]

Yes, you can. We don't need to see your entire project. Copy it and then cut it down to a sample file that displays the issue. That's what a lot of people have to do here.

[travelkid]

here is the simplified book. So far I havent been able to make it work, ill keep trying. You should get the idea, I marked in red in the excel sheet the values which dont work.

Best

[AliGW]

Vielen Dank.

One of us will take a look shortly.

[travelkid]

I tried to the change the settings: Use seperators not from the system but manual ones. One can find this in options --> advanced. This worked for a while. When I closed the file and reopened, it didnt work anymore. This feels like a bug. Its so unlogical that at one point it works fine and in a later userform not anymore. Also it seems that when I play around with the problem for an hour or two it changes it settings to what I want...

Help needed here!

[torachan]

There is a confusion of formatting throughout the sheet.
e.g. in some columns one cell is formatted 'scientific' the next 'general' followed by 'numeric' four point.
'general' has no specific numbering format, it will try and translate what is entered, sometimes rightly, sometimes wrongly.
Have you tried replace function (ctrl H), then format the entire area 'numeric' to whatever accuracy is required.

[travelkid]

This is still unsolved. When I read out the values from the excel sheet, from the cells that are formatted numerics with a point instead of a comma it still translates the points into commas.. This is killing me

[travelkid]

At the end of the userform in the Initialize part I changed from Integer to Double..

Please Login or Register  to view this content.

This seemed to be a solution, as it wokred once but not twice .. Awesome

[torachan]

Are you referring to

Please Login or Register  to view this content.

I am totally confused as this seems to be some strange attempt to format a UserForm control not your worksheet.
I am surprised if this worked once !
I have tried to run the UserForm independently however without success as there is so much referencing missing.
Start from the beginning,
Put 'Option Explicit' as very first line of your code.
Then run 'debug', and rectify each fault in turn, such as dimension 'Dim' each variable etc.