Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cell Format
Yes VBA/Macro program most probably reads the decimal format from the Windows Regional Settings. In "my case" it is Swedish Regional settings and the decimal separator is , comma. Then when I run my VBA code it stops at a code where it has populated a parameter ABHR with value 5,35342 and...- SAS343
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Cell Format
Hello! Does anyone know how I can easily define the format I want to use for a specific cell when calculating numbers with decimals. What I mean is I need the numbers to be in 123.45 format with a dot as decimal-separator, but the cell only accepts comma separated decimals 123,45. Because I...- SAS343
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Application.International(xlCountrySetting)
Hello! I have "inherited" some Visual Basic code as shown below. This code only accept the pprogram to run in English (United States) Language setting. However I need the program to run in arbitrary (all) language settings and specifically in Swedish, Norweigian and Danish language settings...- SAS343
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
