VBA "TypeName" international issues

  • Thread starter Thread starter johnfromlondon
  • Start date Start date
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
 
Yes it will, but you can also do it more directly using If TypeOf:


If TypeOf vr_abc Is Worksheet Then
 
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)
 
Back
Top