formatting with a listbox ?

[ricksimm]

I want to display an employee social security number, the employee name, and the employee address on one row of a listbox with a new row for each new employee. I would like to display this information as if each piece of information is in a separate column so that the info would line up vertically when viewed in the listbox. It would be like a multiple column listbox. Is this possible? Thanks.

 

[Legacy 98055]

I thought a picture might "save a thousand words".
Download the example. If your listbox is in a userform, it is almost the same but we will have to use the controlsource property instead of LinkedCell and ListFillRange.

ricksimm.zip (9.24 kb)