Forum Discussion

Siena_IDO_1959's avatar
Siena_IDO_1959
Copper Contributor
Jun 16, 2020

Problemes with Excel VBA/Macro

I am working in an application with Userforms.

The application must run in different computers. It means it can be "Spanish" Excel, "English" Excel, etx. and in any case decimal character can be "." or ",".

I have included in the application a definition valid for the decimal character.

However, if I run the "Spanis" Excel and decimal character is "." it doesn't work properly.

In order to capture data from an excel file, let's say, 5.25; the instruction

A = Cell("A1").Value captures 5,25

In order to capture 5.25 I must say

A = Cell("A1").Text

And once I have captures the calue, if I want to operate with A, if I write

B = Dbl(A), instead of having 5,25 what I obtain is 525 (without comma).

Any solution for this problem?

I need to pass the values to a userform and I read the values from the userform. For this reson I must "show" thae values with ".".   

No RepliesBe the first to reply

Resources