Hi Folks
Since there is no option to format message boxes, I was wondering if there if a way to find the maximum number of characters before Excel does a line break in a messagebox. Apparently that number varies depending on the excel version and/or screen resolution, but I'm not sure about that. I can only tell that the number of characters for a single line varies depending on the screen and/or office version. For example, oddly enough, the standard company screen (i.e. around 19", Win8, Excel 2013) shows less line breaks than my personal PC (Win10, Excel 2016, and high resolution) for the same message.
The reason for that is that I'd like to set the length of a splitter line (consisting of underscores) in order to make a larger, multi-line message more readable.
Any ideas?
Reply With Quote