software

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--
Robert57
------------------------------------------------------------------------
Robert57's Profile: www.excelforum.com/member.php...oamp;userid=29838
View this thread: www.excelforum.com/showthread...hreadid=495444
RobertJust 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 group
to look for the fuction.Thiem--
Thiem
------------------------------------------------------------------------
Thiem's Profile: www.excelforum.com/member.php...oamp;userid=27474
View this thread: www.excelforum.com/showthread...hreadid=495444Hi 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?obert57??ezt ?rta:

gt;
gt; Hi
gt; I'm new here and first problem is for me what to call a function in
gt; english. I'm running a swedish Excel so Do you have a translation table
gt; or something so I know what to write so you understand.
gt;
gt;
gt; Robert
gt;
gt;
gt; --
gt; Robert57
gt; ------------------------------------------------------------------------
gt; Robert57's Profile: www.excelforum.com/member.php...oamp;userid=29838
gt; View this thread: www.excelforum.com/showthread...hreadid=495444
gt;
gt;

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)quot;Robert57quot; gt; wrote in
message ...
gt;
gt; Hi
gt; I'm new here and first problem is for me what to call a function in
gt; english. I'm running a swedish Excel so Do you have a translation table
gt; or something so I know what to write so you understand.
gt;
gt;
gt; Robert
gt;
gt;
gt; --
gt; Robert57
gt; ------------------------------------------------------------------------
gt; Robert57's Profile:
www.excelforum.com/member.php...oamp;userid=29838
gt; View this thread: www.excelforum.com/showthread...hreadid=495444
gt;

Bob Phillips Wrote:
gt; Robert,
gt;
gt; If you enter a function in a cell, and then go into the VBIDE
gt; (Alt-F11), in
gt; the immediate window (Ctrl-G), just type
gt;
gt; ?Activecell.Formula
gt;
gt; this will give you the English equivalent, as VBA works in English.
gt;
gt;
gt; QUOTE]
gt;
gt; Tnx Bob
gt; It was an easy way to do it and I will use it in the future.
gt;
gt; Robert
gt;
gt; The Hungarian way was not working on my Swedish Excel. Tnx anyway.--
Robert57
------------------------------------------------------------------------
Robert57's Profile: www.excelforum.com/member.php...oamp;userid=29838
View this thread: www.excelforum.com/showthread...hreadid=495444Hi 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?ob Phillips??ezt ?rta:

gt; Robert,
gt;
gt; If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in
gt; the immediate window (Ctrl-G), just type
gt;
gt; ?Activecell.Formula
gt;
gt; this will give you the English equivalent, as VBA works in English.
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;Robert57quot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hi
gt; gt; I'm new here and first problem is for me what to call a function in
gt; gt; english. I'm running a swedish Excel so Do you have a translation table
gt; gt; or something so I know what to write so you understand.
gt; gt;
gt; gt;
gt; gt; Robert
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Robert57
gt; gt; ------------------------------------------------------------------------
gt; gt; Robert57's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29838
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=495444
gt; gt;
gt;
gt;
gt;

You can download a formula translator he

members.chello.nl/keepitcool/download.html

--
Kind regards,

Niek Otten

quot;Robert57quot; gt; wrote in
message ...
gt;
gt; Hi
gt; I'm new here and first problem is for me what to call a function in
gt; english. I'm running a swedish Excel so Do you have a translation table
gt; or something so I know what to write so you understand.
gt;
gt;
gt; Robert
gt;
gt;
gt; --
gt; Robert57
gt; ------------------------------------------------------------------------
gt; Robert57's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29838
gt; View this thread: www.excelforum.com/showthread...hreadid=495444
gt;
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?iek Otten??ezt ?rta:

gt; You can download a formula translator he
gt;
gt; members.chello.nl/keepitcool/download.html
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Robert57quot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hi
gt; gt; I'm new here and first problem is for me what to call a function in
gt; gt; english. I'm running a swedish Excel so Do you have a translation table
gt; gt; or something so I know what to write so you understand.
gt; gt;
gt; gt;
gt; gt; Robert
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Robert57
gt; gt; ------------------------------------------------------------------------
gt; gt; Robert57's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=29838
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=495444
gt; gt;
gt;
gt;
gt;

Yep.

In the immediate window:

activecell.formula = quot;=yourformulaherequot;

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

And if you have the formula in R1C1 notation:
activecell.formular1c1 = quot;=yourformulaherequot;

(And make sure that the activecell is where you want it lt;vbggt;.)Stefi wrote:
gt;
gt; Hi Bob,
gt;
gt; Is there a similar way in the opposite direction? E.g. if I receive a
gt; function tip from you in English, does XL have any feature that translate it
gt; into a national language?
gt;
gt; Stefi
gt;
gt; ?ob Phillips??ezt ?rta:
gt;
gt; gt; Robert,
gt; gt;
gt; gt; If you enter a function in a cell, and then go into the VBIDE (Alt-F11), in
gt; gt; the immediate window (Ctrl-G), just type
gt; gt;
gt; gt; ?Activecell.Formula
gt; gt;
gt; gt; this will give you the English equivalent, as VBA works in English.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; RP
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt;
gt; gt; quot;Robert57quot; gt; wrote in
gt; gt; message ...
gt; gt; gt;
gt; gt; gt; Hi
gt; gt; gt; I'm new here and first problem is for me what to call a function in
gt; gt; gt; english. I'm running a swedish Excel so Do you have a translation table
gt; gt; gt; or something so I know what to write so you understand.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Robert
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Robert57
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; Robert57's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=29838
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=495444
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

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

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Dave Petersonquot; gt; wrote in message
...
gt; Yep.
gt;
gt; In the immediate window:
gt;
gt; activecell.formula = quot;=yourformulaherequot;
gt;
gt; Remember to double up your quotation marks if have them:
gt; activecell.formula = quot;=if(a1=quot;quot;quot;quot;,quot;quot;quot;quot;,a1)
gt;
gt; And if you have the formula in R1C1 notation:
gt; activecell.formular1c1 = quot;=yourformulaherequot;
gt;
gt; (And make sure that the activecell is where you want it lt;vbggt;.)
gt;
gt;
gt; Stefi wrote:
gt; gt;
gt; gt; Hi Bob,
gt; gt;
gt; gt; Is there a similar way in the opposite direction? E.g. if I receive a
gt; gt; function tip from you in English, does XL have any feature that
translate it
gt; gt; into a national language?
gt; gt;
gt; gt; Stefi
gt; gt;
gt; gt; ?zBob Phillips??ezt ?rta:
gt; gt;
gt; gt; gt; Robert,
gt; gt; gt;
gt; gt; gt; If you enter a function in a cell, and then go into the VBIDE
(Alt-F11), in
gt; gt; gt; the immediate window (Ctrl-G), just type
gt; gt; gt;
gt; gt; gt; ?Activecell.Formula
gt; gt; gt;
gt; gt; gt; this will give you the English equivalent, as VBA works in English.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; RP
gt; gt; gt; (remove nothere from the email address if mailing direct)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Robert57quot; gt;
wrote in
gt; gt; gt; message ...
gt; gt; gt; gt;
gt; gt; gt; gt; Hi
gt; gt; gt; gt; I'm new here and first problem is for me what to call a function in
gt; gt; gt; gt; english. I'm running a swedish Excel so Do you have a translation
table
gt; gt; gt; gt; or something so I know what to write so you understand.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; Robert
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Robert57
gt; gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; gt; Robert57's Profile:
gt; gt; gt; www.excelforum.com/member.php...oamp;userid=29838
gt; gt; gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=495444
gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson