Column Heads?
Hi All,
I'm struggling with column headings in listbox. Despite Tom Ogilvy pointing me in the right direction, I'm just to ignorant to understand his advice. Tom Said "The columnheading can only be set by using the rowsourc (userform) or listfillrange (worksheet) Property to populate the list If so, then the row above the specified range is used to populate th column headings. If the rowsource/listfillrange starts in row1, then i used the column letters. You can't populate them if you don't bind the control list to th sheet. " My trouble is I don't know out about 'binding the control list to th sheet'. Would someone be kind enough to show me what to do. Thankx pals Coli -- Message posted from http://www.ExcelForum.com |
Column Heads?
After a bit of thinking and groping about I managed to get column head
to work by putting th following into :- Private Sub UserForm_Initialize() ListBox1.ColumnHeads = True 'show headings ListBox1.RowSource = "B2:D2" 'point at column headers offset? I had three colunm's so "B2:D2" gives three headings, although I di notice to get the right result I had to point to data at row 2 and no row where the data was? Hope this helps any one else trying to get this working. Noggin PS still like to know why the offset though -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com