I am trying to use a multi-select listbox in a button macro for a multiple user survey, but I am having a few issues that are breaking my brain. currently, I am only able to assign the listbox to 1 shape as a macro button and it works as intended. it outputs to the selected cell (set in the list properties, not set in the macro) giving the multiple selected responses.

one of the issue I'm having is that I have several hundred users I need to set up this list macro on the same spreadsheet. I need to have the output placed in a corresponding list on a separate sheet with each user being able to select different options than other users.

another issue I'm having is that the listbox will stay at the top of the page, only popping up underneath the first button.

Please Login or Register  to view this content.