ColumnWidths property

[Olle Sundin]

Pls help!
My client in Taiwan got this message:
Could not set the ColumnWidths property. Type mismatch
in statement:
ActiveWorkbook.ActiveSheet.ComboBox2.ColumnWidths = "1
cm;4.2 cm;1.1 cm;1.2 cm;1.2 cm"
The application is used over the whole world without any
problem. The user says he use Win/98 and Office 2000. All
parameters in Regional settings are OK.
Can it be a version of a DLL-file that doesn't work
properly or ....

Best regards,
Olle

 

[Dick Kusleika]

Olle

It worked OK for me using Win98SE and Off2000.

The only way I could reproduce that message is to change "cm" to something
nonsensical. That makes me think it's a language issue. It doesn't
recognize cm as a valid measurement.

If you can have this user test something, here's what I would do: When you
get the error, choose Debug and type this in the immediate window

ActiveSheet.Combobox2.ColumnWidths = "1;4.2;1.1;1.2;1.2"

That will use the default measurement (which may not be what you want), but
if you don't get an error, then I think that supports the theory that it's a
language issue.

I don't know how to fix it if it is a language issue, but it may, at least,
get you on the right track to a solution.

 

[Olle Sundin]

Hi Dick,

Thanks for your help.
Yes, this is also my theory. Also, as long as the
application is working around the world (in many
countries) without any problem I know is must be a
language issue. I was hoping to find an answer like:
replace file a with file b
As you probably know it is very hard to find that
yourself, specially when my client is in Taiwan and I'm in
Sweden!
Once again - thanks for your help.

Regards,
Olle