I use and have formatted my cells according to the US system (decimal point instead of decimal comma) and if I use computer which is adjusted to european decimal 'comma' instead of decimal point I got sort of messed up values (for instance, if cell formated for three digits /decimal places behind decimal point I get instead 4 digits number and additional three decimal places behind decimal comma). Any easy way to fix this total 'mess'?
This bellow is an example of line of code when I get cell value (in original format) from sheet to User Form's text box 1
TextBox1.Value = Cells(4,5).Text
and this bellow is when I send and save some entered value to the respective cell from User Form's text box 1
Cells(4,5).Value = TextBox1.Text
Any conclusive help will be very much appreciated
Danny
This bellow is an example of line of code when I get cell value (in original format) from sheet to User Form's text box 1
TextBox1.Value = Cells(4,5).Text
and this bellow is when I send and save some entered value to the respective cell from User Form's text box 1
Cells(4,5).Value = TextBox1.Text
Any conclusive help will be very much appreciated
Danny