Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multilanguage translation
Hi,
I need to adapt a German VB script used in Excel into a version which will work in Europe. The problem is that the Line/Colon references have different names in the different countries. How can I easily adapt a script into a multilanguage version? Here an extract of the German Version with ZS references: 'Mise en forme conditionnelle première colonne With Range("A6:A" + CStr(Range("LastLine").Value + 5)) .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="=ZS6=100%" .FormatConditions(1).Font.Strikethrough = True .FormatConditions.Add Type:=xlExpression, Formula1:= _ "=(ZS6<1)*(ZS2+ZS3<=Z4S2)*(ZS2<"""")" With .FormatConditions(2).Font .Bold = True .Italic = False .ColorIndex = 3 End With .FormatConditions.Add Type:=xlExpression, Formula1:= _ "=(Z4S2=ZS2)*(ZS2+ZS3=Z4S2)*(ZS2<"""")" With .FormatConditions(3).Font .Bold = True .Italic = False .Strikethrough = False .ColorIndex = 5 End With End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multilanguage custom menus | Excel Programming | |||
multilanguage custome menu | Excel Discussion (Misc queries) | |||
Value translation | Excel Programming | |||
Multilanguage issue | Excel Programming | |||
Need Translation | Excel Programming |