Excel VBA string WIDTH

Question

In excel string length not equal to string size same length string with diff characters (spaces) looks shorter each other.

So then I trying to align two columns in drop down list I get result as in picture below in cell HAVE I need to do like in cell NEED

enter image description here

So how to get string width but not length?

It's kind of complex as it depends not only on the font that you are using but also on the screen resolution. — Siddharth Rout, Commented Apr 30, 2014 at 7:13
so how to get list box with multi column so in first column values from first column in second list column get values from second column? — user3588043, Commented Apr 30, 2014 at 7:20
You can use multi column listbox with a predefined width. I have already answered a similar question few (or maybe more) months back — Siddharth Rout, Commented Apr 30, 2014 at 7:24

avb · Accepted Answer · 2014-04-30 09:30:20Z

2

Use monospace font (courier, consolas, lucida console etc).
This will do.

answered Apr 30, 2014 at 9:30

avb

1,85311 gold badge1414 silver badges2424 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1