VBA "TypeName" international issues

J

johnfromlondon

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
 
J

JE McGimpsey

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


If TypeOf vr_abc Is Worksheet Then
 
B

Bob Phillips

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