this item 02
another one 03
item 4 04
Anyone know of a way to create proper spacing between strings in an Excel Dropdown without simply using a predetermined number of spaces? For example, in the above quote the second column (01,02, etc) is approx lined up horizally. Of course different fonts & characters make using the Len() function inadequate. I was thinking there might be a way to measure the text, but I wouldn't want to get too complex, nor would I wan't to have the width measured after display - as in using gdip.
One idea I had was to put the each item in the first column in separate columns - autofit - & then use the column width. I was wondering if anyone had any better ideas.