eddiev1972
New Member
- Joined
- Mar 22, 2010
- Messages
- 38
Is there a way to have a divider/border/line appear between columns of a multi-column list box?
Thank you for any information!
Thank you for any information!
-
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.
Multi-Column Listbox - Borders?
- Thread starter eddiev1972
- Start date
As a matter of fact, there is a way to achieve this even though there is no functionality in the listbox object... all it requires is a little lateral thinking.
1) When creating the multi column listbox, set the 'ColumnCount' property to twice the number of columns you need minus 1.
2) When setting the 'ColumnWidths' properties, set every other column to 10 pts.
3) If using the 'Additem' instruction, assign a vertical line (|) to every even numbered column.
4) If using the 'RowSource' property, put an extra column between each of the source columns and fill the extra columns with vertical lines (|).
Regards
Rob52
1) When creating the multi column listbox, set the 'ColumnCount' property to twice the number of columns you need minus 1.
2) When setting the 'ColumnWidths' properties, set every other column to 10 pts.
3) If using the 'Additem' instruction, assign a vertical line (|) to every even numbered column.
4) If using the 'RowSource' property, put an extra column between each of the source columns and fill the extra columns with vertical lines (|).
Regards
Rob52
Upvote
0
