Problem with Language

[Robert57]

Hi
I'm new here and first problem is for me what to call a function in
english. I'm running a swedish Excel so Do you have a translation table
or something so I know what to write so you understand.


Robert

 

[Thiem]

Robert


Just go ahead and explain what you want. If we think we can help you
we will explain what type of fuction to use and and under whicg grou
to look for the fuction.


Thie

 

[Guest]

Hi Robert,

In Hungarian Excel we found a FUNCS.XLS file in folding
C:\Program Files\Microsoft Office\Office11\1038
that contained the translation table of English and Hungarian function names.
Have a try, perhaps there is a similar table also in the Swedish version.

Regards,
Stefi


„Robert57†ezt írta:

 

[Bob Phillips]

Robert,

If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in
the immediate window (Ctrl-G), just type

?Activecell.Formula

this will give you the English equivalent, as VBA works in English.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Robert57]

Robert,

If you enter a function in a cell, and then go into the VBIDE
(Alt-F11), in
the immediate window (Ctrl-G), just type

?Activecell.Formula

this will give you the English equivalent, as VBA works in English.


QUOTE]

Tnx Bob
It was an easy way to do it and I will use it in the future.

Robert

The Hungarian way was not working on my Swedish Excel. Tnx anyway.

 

[Guest]

Hi Bob,

Is there a similar way in the opposite direction? E.g. if I receive a
function tip from you in English, does XL have any feature that translate it
into a national language?

Stefi


„Bob Phillips†ezt írta:

Robert,

If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in
the immediate window (Ctrl-G), just type

?Activecell.Formula

this will give you the English equivalent, as VBA works in English.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Niek Otten]

You can download a formula translator here:

http://members.chello.nl/keepitcool/download.html

 

[Guest]

Thanks, Niek, it's a fine add-in, but for the moment it doesn't speak
Hungarian. Maybe it will be added in the future, as it's mentioned in the
About-text!

Regards,
Stefi


„Niek Otten†ezt írta:

 

[Dave Peterson]

Yep.

In the immediate window:

activecell.formula = "=yourformulahere"

Remember to double up your quotation marks if have them:
activecell.formula = "=if(a1="""","""",a1)

And if you have the formula in R1C1 notation:
activecell.formular1c1 = "=yourformulahere"

(And make sure that the activecell is where you want it <vbg>.)

Hi Bob,

Is there a similar way in the opposite direction? E.g. if I receive a
function tip from you in English, does XL have any feature that translate it
into a national language?

Stefi

„Bob Phillips†ezt írta:

 

[Bob Phillips]

But this does assume that you have that language version installed.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks Dave and Bob, that is the case, I run a Hungarian version, and this
translation method works nicely!

Regards,
Stefi


„Dave Peterson†ezt írta: