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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
formatting with a listbox ?
- Thread starter ricksimm
- Start date
L
Legacy 98055
Guest
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)
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)
Upvote
0
Similar threads
- Question
