Hello,
I need to fill a listbox with more than 24 (A-Z) collumns, with precisely 26 collumns (A-AB) and when displaying the listbox the last two collumns i cant see then in the listbox.
here's the code
Can anyone help me?
Please Login or Register to view this content.
Your are specifying the column widths for 27 columns, not 26.
By the way, if only a few of the columns are going to be visible then why not put the data from those columns into an array and use that to populate the listbox?
If posting code please use code tags, see here.
To give you a hint.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Where should I be putting this code??Originally Posted by bakerman2
To give you a hint.
Please Login or Register to view this content.
My best guess without seeing your data.
Please Login or Register to view this content.
Sorry i've checked my code and i was doing it wrong
This should be the right code
Thank you very much for your help anywayPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks