Extracting all values in a list box into excel

**concatch** · 05-23-2013, 11:26 AM

Hi,

I have a user form with a listbox. The user is able to add to this list box as many items as he wants. What I would like to do is be able to export from this list box into an excel worksheet. I would like to hardcode where the first value should be, say in cell A1, and the rest of the values should automatically populate A2, A3, A4 etc based on how many items there are in the list box.

I've tried several methods to try do this. Problem is a lot of them require me to select a specific item in the list box and then it can only export that. I would like all the items to be exported. I found a snippet of code online I've modified but I cant get it to work. It only exports a single selected value.

Any help would be appreciated

HTML Code:

**nilem** · 05-23-2013, 12:12 PM

Concatch, can you attach an example of your file for a better understanding of your problem

**concatch** · 05-23-2013, 12:23 PM

I just solved the issue. The above codes if statement required that you select each item in the list box and add it individually.

This code will print all the values to excel

HTML Code:

Thanks though