Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put one of the Regional Settings in a variable
Hi,
i would like to know if it is possible to look into my Regiona Settings and take one of the paramaters there (being the decima symbol) and put it into a variable. Doing all this in my VBA code... if it's possible please tell me how! thanks for anyone trying Holysou -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put one of the Regional Settings in a variable
You can get the internationals decimal setting with code like
Dim DecSep As String DecSep = Application.International(xlDecimalSeparator) Debug.Print DecSep -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "holysoul " wrote in message ... Hi, i would like to know if it is possible to look into my Regional Settings and take one of the paramaters there (being the decimal symbol) and put it into a variable. Doing all this in my VBA code... if it's possible please tell me how! thanks for anyone trying Holysoul --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put one of the Regional Settings in a variable
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regional settings | Excel Worksheet Functions | |||
Regional Settings with Date | Excel Discussion (Misc queries) | |||
regional settings | Excel Worksheet Functions | |||
Regional Settings | Excel Discussion (Misc queries) | |||
Changing Regional Settings from VBA | Excel Programming |