Export contents of listbox to new excel workbook

[jstn]

I've got a userform that searches a database for certain criteria and displays the results in a list box with 7 columns. I'm now trying to figure out the code to export the contents of that listbox into a new workbook executing with a command button, appreciate any help!

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

[mehmetcik]

Hi

This is all you need to fill and store entries from a listbox.
I have included a few redundant lines to give you some hints.

Please Login or Register  to view this content.

This code stores the whole listbox. How often will you need to do that?

Please Login or Register  to view this content.

[jstn]

That does the trick, thank you! seems so simple, I suspected it would be but couldn't nail it down.
The whole list box contents is what I needed, the filtering is done on the userform.

A small adjustment if possible, the list box doesn't have headers, but the database it pulls from does, could I have the headers added into the exported file? Could we also size the columns in the workbook to fit the data?

[AlphaFrog]

A small adjustment if possible, the list box doesn't have headers, but the database it pulls from does, could I have the headers added into the exported file? Could we also size the columns in the workbook to fit the data?

Please Login or Register  to view this content.

[jstn]

Thank you again, that's perfect! Is there a way to declare the column headers?

[AlphaFrog]

You're welcome.

Please Login or Register  to view this content.