Hi all,

I have a userform (Userform1) with 3 comboboxes (Combobox1, Combobox2, Combobox3) and an "Add" button (Commandbutton1). My question is, how can I get the selected text from Combobox1 (for example), click the "Add" button and get the text pasted into cell A9?

Any help will be much appreciated and if i've left any vital info out please let me know

Thanks in advance