Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ricky Johnson   on Nov 13 In MS Office Category.

  
Question Answered By: Shaun Thomas   on Nov 13

You said
The "solutions" I've found from a Google search all say that
> the user should write the data to a sheet and "bind" the
> records to the listbox. This is impractical, since the
> starting record count exceeds the maximum number of rows in
> an Excel worksheet.

Do you mean you are going to have more than 65536 rows in the listbox?

If not, do what you need to do to get the array containing the data you want
in the listbox, write the array to a sheet and set the rowsource for the
listbox to the sheet. I think that should work.

Share: 

 

This Question has 19 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Populate Listbox Column Headings Or get search suggestion and latest updates.


Tagged: