| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean in VBA are returned in local language
Thanks both of you. That helped.
Regards, Reto Bob Phillips wrote: Why not test the boolean directly Why not test the Boolean directly Dim bolVal As Variant bolVal = cell.Font.Strkethrough If bolVal = FALSE Then -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... Hi, My VBA script reads some values from cells and sends them to a webservice. I just realized that using a German Excel e.g. cell.Font.Strikethrough is returned as Wahr/Falsch instead of True/False. I tried following code snippet I found online but unfortunately didn't help either: ..... Dim bolVal As Variant bolVal = cell.Font.Strkethrough If CStr(bolVal ) = "False" Then ' Unfortunately this didn't help. ....... Has anybody an idea how to convert this from any language to True/False? Reto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
| language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
| Language of the local PC | Excel Programming | |||
| How to change the excel format from language to language? | Excel Discussion (Misc queries) | |||
| Reference styles and local/non-local formulae - international problems. | Excel Programming | |||
Threaded Mode
