Extracting all values in a list box into excel

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: