ColumnWidths property
 

Hi

I created a form which contains some list box controls. I set the
ColumnWidths property with the following VBA command:

..ColumnWidths = "0;48;0"

This works fine except with a chinese Excel & Windows version. The following
error message is displayed:

Run-time error '2147352571 (80020005)';
Could not set the ColumnWidths property. Typeconflict.


I suppose that this has something to do with the list seperator, but I don't
know how to set the right seperator. Any ideas?

Tom

ColumnWidths property
 

Tom,

Googling around I found this. Don't know if it helps:

? Application.International(xlListSeparator)
,

hth,

Doug

"Tom" wrote in message
...
Hi

I created a form which contains some list box controls. I set the
ColumnWidths property with the following VBA command:

.ColumnWidths = "0;48;0"

This works fine except with a chinese Excel & Windows version. The
following error message is displayed:

Run-time error '2147352571 (80020005)';
Could not set the ColumnWidths property. Typeconflict.


I suppose that this has something to do with the list seperator, but I
don't know how to set the right seperator. Any ideas?

Tom

ColumnWidths property
 

Doug

I already tested this but this doesn't work.

Thomas



"Doug Glancy" schrieb im Newsbeitrag
...
Tom,

Googling around I found this. Don't know if it helps:

? Application.International(xlListSeparator)
,

hth,

Doug

"Tom" wrote in message
...
Hi

I created a form which contains some list box controls. I set the
ColumnWidths property with the following VBA command:

.ColumnWidths = "0;48;0"

This works fine except with a chinese Excel & Windows version. The
following error message is displayed:

Run-time error '2147352571 (80020005)';
Could not set the ColumnWidths property. Typeconflict.


I suppose that this has something to do with the list seperator, but I
don't know how to set the right seperator. Any ideas?

Tom

ColumnWidths property
 

In the online help the problem is described as follows:

To separate column entries, use semicolons (;) as list separators. In
Windows, use the list separator specified in the Regional Settings section
of the Windows Control Panel to change this value.

I tried to use the Application.International(xlListSeparator) property, but
it doesn't seem to be the right way.


"Doug Glancy" schrieb im Newsbeitrag
...
Tom,

Googling around I found this. Don't know if it helps:

? Application.International(xlListSeparator)
,

hth,

Doug

"Tom" wrote in message
...
Hi

I created a form which contains some list box controls. I set the
ColumnWidths property with the following VBA command:

.ColumnWidths = "0;48;0"

This works fine except with a chinese Excel & Windows version. The
following error message is displayed:

Run-time error '2147352571 (80020005)';
Could not set the ColumnWidths property. Typeconflict.


I suppose that this has something to do with the list seperator, but I
don't know how to set the right seperator. Any ideas?

Tom

ColumnWidths property
 

It's "Application.International(xlRowSeparator)"


--
bighead


------------------------------------------------------------------------
bighead's Profile: http://www.excelforum.com/member.php...o&userid=27048
View this thread: http://www.excelforum.com/showthread...hreadid=531674