10/4/2023 0 Comments Free downloads Kalmuri 3.5![]() Hi Jan Karel, thanks for prompt post (as well as any of your interesting articles) Perhaps you need to convert explicitly using the Str function to get US syntax or using Cstr to get the local stringĬomment by: TM (7-4-2022 21:11:00) deeplink to this comment Your code would return a string with the windows decimal separator due to the string conversion. 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |