VBA "TypeName" international issues

Does anyone know whether the TypeName VBA function will return strings
in english with a non english version of windows.

for example, would the following work on a non english configured
version of Windows\Excel.

if TypeName(vr_abc)="Worksheet" then
do something....
end if

Many thanks
John

Yes it will, but you can also do it more directly using If TypeOf:


If TypeOf vr_abc Is Worksheet Then


In article <[email protected]>,
[email protected] wrote:

> Does anyone know whether the TypeName VBA function will return strings
> in english with a non english version of windows.
>
> for example, would the following work on a non english configured
> version of Windows\Excel.
>
> if TypeName(vr_abc)="Worksheet" then
> do something....
> end if

John,

I think VBA is US English all the way through, so that should work.

--

HTH

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


<[email protected]> wrote in message
news:[email protected]...
> Does anyone know whether the TypeName VBA function will return strings
> in english with a non english version of windows.
>
> for example, would the following work on a non english configured
> version of Windows\Excel.
>
> if TypeName(vr_abc)="Worksheet" then
> do something....
> end if
>
> Many thanks
> John
>