Adding to sheet from Combo Box and Command Button VBA
<p>I'm trying to design a user form that currently looks something like this:</p>

<p><a href="https://i.stack.imgur.com/1Rdqg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1Rdqg.png" alt="enter image description here"></a></p>

<p>The Combo Box uses A1:A5 to generate its list and then whatever is selected is linked into cell D12.</p>

<p>However I want the user to be able to populate a new list based on the options in the combo box by using the Add command button.</p>

<p>So for example the user would select test2 from the combo box, click Add and then select another option, say test4, click Add again and it would appear beneath test2 in cell D13.</p>

<p>I've used VBA before but never really for Form Controls, only for manipulating data so this is fairly new to me. Most of the tutorials online can't seem to help either, anyone have any suggestions please?</p>