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
and here is the relevant one in the second formPlease Login or Register to view this content.
Many thanks to whoever can helpPlease Login or Register to view this content.
Bookmarks