Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox, Controlling columnwidths i curtain | Excel Programming | |||
PasteSpecial Paste:=ColumnWidths | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
listbox.Columnwidths question | Excel Programming | |||
Paste columnwidths in Xl2k problem | Excel Programming |