View Full Version : VBA userform - decimal separator
agfac
12-30-2013, 08:17 PM
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
12-30-2013, 11:42 PM
Check the system settings for the decimal separator
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
@ 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
12-31-2013, 05:52 AM
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
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.