VBA userform - decimal separator

[agfac]

Hi,

I've a VBA userform that finds values in an excel workbook and fill an textbox with that value. I used find and offset to do that. The value is for example "1,4".

On my PC, it fill correctly the textbox with value "1,4" but if I try to run the same VBA userform on another PC it fill the textbox with the value "1.4".

Why is it happenning?

Thanks

[Aussiebear]

Check the system settings for the decimal separator

[GTO]

Hi all,

Not tried whatsoever...

I am wondering if on the 2nd PC, the cell's formatting comes into play. Again, very much not thought through, but have you tried using .Text rather than .Value to grab the cell's return?

@Ted:

A belated Merry Christmas my friend, and a Happy New Year to you and yours :-)

Mark

[GTO]

@ agfac:

Please see: http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters

@All: cross-posted at: http://www.mrexcel.com/forum/excel-questions/747562-visual-basic-applications-userform-decimal-separator.html

Mark

[agfac]

Hi all,

Not tried whatsoever...

I am wondering if on the 2nd PC, the cell's formatting comes into play. Again, very much not thought through, but have you tried using .Text rather than .Value to grab the cell's return?

@Ted:

A belated Merry Christmas my friend, and a Happy New Year to you and yours :-)

Mark

I've replaced .Value by .Text and it works!

Thanks

[GTO]

I've replaced .Value by .Text and it works!

Thanks

You are very welcome. I hope you read the part about cross-posting politely.

A Happy and Prosperous New Year to you and yours,

Mark