View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default 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