I am looking for help with a Excel macro that would first, clear any current selected values in a listbox, then return multiple slected values from a worksheet (not user form) listbox and place the concatenated values into a specific cell on the worksheet.
I am using Excel 2007. I create the list box by Selecting the Developers TAB, Insert a ListBox (Form Control, not Active-X) by dragging the ListBox onto the current worksheet. I then populate the contents of the ListBox by selecting with RMB and setting the Format-Control TAB entries (Range of cells from Sheet2, selecting the "Extend" selection type.
Ideally, this macro would be run upon the user selecting a Form-Control Button
I am using Excel 2007. I create the list box by Selecting the Developers TAB, Insert a ListBox (Form Control, not Active-X) by dragging the ListBox onto the current worksheet. I then populate the contents of the ListBox by selecting with RMB and setting the Format-Control TAB entries (Range of cells from Sheet2, selecting the "Extend" selection type.
Ideally, this macro would be run upon the user selecting a Form-Control Button