I'm new to using VBA and I'm trying to figure out how, if possible to copy selected items from a listbox to cells on another sheet? I am using Excel for Mac 2016 and I know it doesn't have all of the same features as previous versions or the Windows versions.
Also, I will be having several listboxes and want to be able to copy the selected items to the next blank cell. I would also like it so that if the item within the listbox is deselected if it would be possible to remove it from the cell that it had previously been copied to.
Thanks in advance.
Also, I will be having several listboxes and want to be able to copy the selected items to the next blank cell. I would also like it so that if the item within the listbox is deselected if it would be possible to remove it from the cell that it had previously been copied to.
Thanks in advance.
