Hello everyone,

I am trying to simulate 'columns' in a msgbox.

I though about measuring the length (len) of all the lines in the '1st' column and then add x * " " followed by the '|' character.
But the issue is the space doesn't have the same 'pixel length' of a number for instance.

With this formula: 
WorksheetFunction.Rept(" ", lMaxStg - lenStg(i)) 'add space between last character and the limit set at '|'
I get that:

Capture.PNG

which is of course nothing likes a proper column...

Would someone know how I can achieve a proper column?

thanks a lot!