OR formula, translation to swedish please

S

Stefi

Hi Freddie,
I don't know Swedish, but Excel (Swedish language version) does. Write this
in VBE Immediate window:
activecell.Formula="=OR(true,false)"
and you will see the translated formula in the active cell. Otherwise look
up it in an English-Swedish dictionary, XL uses the common language
translations!

Regards,
Stefi


„FreddieP†ezt írta:
 
B

Bob Phillips

ELLER

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
F

FreddieP

Hej Stefi, thanx for your help. I just translated it with common language and
it worked but, I didn't get your formula that I find really interesting to
work.

I don't know what a VBE window is?

/Freddie
 
S

Stefi

Hi Freddie,

It's worth while to learn to use Visual Basic Immediate window in order to
solve future translation problems, especially if you write macros using
worksheet functions, because in this case you have to know both English and
translated names of worksheet functions (in the spreadsheet you use the
translated name, in VBA the English name, clever, isn't it). I'm also
continuously suffering from my national language (Hungarian) version, because
translations are often arbitrary and cannot be easily found out. It goes like
this:

Tools/Macro/Visual Basic Editor (or with hotkey Alt-F11)

View/Immediate window


Regards,
Stefi



„FreddieP†ezt írta:
 
Top