I think you must make sure that the string contains valid decimal separator too. In Windows, use the list separator specified in the Regional Settings section of the Windows Control Panel to change this value.'Ĭomment by: Jan Karel Pieterse (7-4-2022 20:17:00) deeplink to this comment 'To separate column entries, use semicolons ( ) as list separators. MS Help reference (/en-us/office/vba/language/reference/user-interface-help/columnwidths-property) specifies: I have to correct my assumption of regional differences, as you have to use semicolons in any case and not commata. Width / 2.1` solved the issue in my case. Width / 2.1` to a string joined by a semicolon via `.ColumnWidths =. ~~>Ĭhanging for both ListBoxes from `.ColumnWidths =. Trying to show the UserForm, VBA raised a runtime error -213735271 (80020005).
Showing last 8 comments of 378 in total ( Show All Comments):Ĭomment by: Jan Karel Pieterse (7-4-2022 10:39:00) deeplink to this commentĪs far as I know, the separator for the columnwidths property does not change for other countries?Ĭomment by: TM (7-4-2022 19:57:00) deeplink to this comment
