Problem with Language

R

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.

:confused:
Robert
 
T

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
 
S

Stefi

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:
 
B

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)
 
R

Robert57

Bob said:
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.
Click to expand...
 
S

Stefi

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)
Click to expand...
 
S

Stefi

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:
 
D

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:
Click to expand...
 
B

Bob Phillips

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

--

HTH

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

Stefi

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:
 
Top