hi, apologies in advance for the potentially daft question.
I have created a Userform ('UserForm1') with a Listbox ('ListBox1') of 10 list options (from a validated and named list on a separate sheet) and two command buttons ('cmdTransfer' and 'cmdClose'). I need the userform to appear when cell C10 is selected on the active sheet, for the user to be able to select multiple items from the list box (I have multi select enabled) and for their selection to fill cell C10 on the active sheet (separated by commas) when the 'cmdTransfer' code is selected. The 'cmdClose' command will close the userform.
would anyone be able to support me with the code for this?
Ps. VBA newbie.
Thanks
I have created a Userform ('UserForm1') with a Listbox ('ListBox1') of 10 list options (from a validated and named list on a separate sheet) and two command buttons ('cmdTransfer' and 'cmdClose'). I need the userform to appear when cell C10 is selected on the active sheet, for the user to be able to select multiple items from the list box (I have multi select enabled) and for their selection to fill cell C10 on the active sheet (separated by commas) when the 'cmdTransfer' code is selected. The 'cmdClose' command will close the userform.
would anyone be able to support me with the code for this?
Ps. VBA newbie.
Thanks
