VBA Data Entry Form ComboBox turn my dot into coma

[Gagahoučte]

I have a data entry form (activities) with a ComboBox that allow to select data from a name of a range of cell itself coming from another data entry form (ouputs). More precisely, after entering the outputs with their reference number (for instance 1.2), it automatically assigne a name to all the reference numbers of the outputs. Then these reference numbers are used in the new form in the ComboBox.

It all works very well except the fact that when I enter the reference number with a dot (e.g. 1.2), while the dot still appear in the list for selection in the ComboBox, it becomes a coma once saved in the sheet (e.g. 1,2), and it highly disturbs me as I need the dot to use the variables later on.

It is worth mentioning that as I am a beginner with coding macros I have followed a tutorial to do the work, and the dude didn't define any variable. I have a feeling that something could be done with defining the variable as string, but all my attempts have failed so far.

here is the code in the first form

Please Login or Register  to view this content.

and here is the relevant one in the second form

Please Login or Register  to view this content.

Many thanks to whoever can help

[sintek]

Hi Gagahoučte

Welcome to the Forum...
First check your PC settings...Change decimal comma to decimal point
If you prefer not to then you can replace the comma with a point such as...

Please Login or Register  to view this content.

Your code can also be simplified...Not wise to make use of select or activate unless really required...

Perhaps you should upload a sample file..see top yellow banner...

[Gagahoučte]

Hi sintek,

Thanks a lot for your answer. I have attached a file as you kindly asked for it and thank you in advance for your support. I have indeed read that select and activate are not the best, but as I mentioned I followed a tuto and didn't have time to work on improving the code myself as my little skills would require lots of work.

Regarding your solution, as my computer is in French it could indeed be the issue, yet I don't necessarily want to change the settings, so I will probably use the other solution. I am busy with something else now but will tr later, unless you find a quick solution for me

Maybe to clarify on the document, it is made for local organisations in Uganda to track projects progress that they are implementing, therefore I am trying to make it as simple as possible. It is important that the three steps of registering the outcomes, outputs and activities remain.

I have just hidden the sheets where they need to record activities and can track the progress. I didn't remove them as the document doesnt contain confidential information. I have filled it with fake once so that you can see what the idea is if you are not familiar with development projects.

Please also note that it is not in it final version yet as I need to improve on entering the variables, notably an option to correct entries without having to modify in the tables themselves. I want to avoid as much as possible that users touch anything in the table to make sure they dont mess with them.

many thanks for your support

[sintek]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Gagahoučte]

Awesome thanks a lot!

[Gagahoučte]

Hi sintek,

works perfectly thanks, but I have another small issue. I used the same code for a new form but I need some data to be considered as numbers and not text so that they can be summed. How can I do that within the code you shared?

Thanks a lot

[sintek]

Upload sample file...Gonna have issues with those decimal point settings perhaps...
I cannot replicate as my settings are correct...
When entering this data is it entered as integers or decimals

Not sure what your setup is so difficult to say...Can always force value i.e

Please Login or Register  to view this content.

[Gagahoučte]

It is in the sheet Activities. The number of beneficiaries should automatically report in the sheet LF_Project but they don't when I insert them with the formular. If I do it manually it works (which I did for row 9 versus row 8 that was entered with the formular.

again, thanks a lot

[sintek]

Just add the red snippets to those variables...

Please Login or Register  to view this content.

[Gagahoučte]

haaaa I was almost there thanks a lot, it works perfectly now

[sintek]

Pleasure...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED...
Tx for rep +