Decimal comma and decimal point issue> User Forms in VBA

saneo

New Member
Joined
Jul 11, 2004
Messages
37
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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,214,826
Messages
6,121,794
Members
449,048
Latest member
greyangel23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top