I am trying to figure out the best way to allow users to select 1-4 options and have the spreadsheet react according to the selections. Assume I have a main spreadsheet which will grab data from between 1-4 spreadsheets. I want a userform or some other method where users can indicate how many and which sheets to import data from.
I've gotten a little confused by some of the wording I've seen online. Can someone explain what a combo box is? Or a listbox?
Also, I've looked into putting checkboxes or option buttons into a userform, but each option leads to its own private sub. It doesn't easily allow for combinations. I can provide more info or an example sheet, but I think I have represented the idea and someone will probably be able to help. Thank you so much for the help or ideas you can provide.
I've decided to add some basic code which may help to illustrate what I mean. Assume the below is for the user to indicate only Spreadsheet 1 (of the 4). The spreadsheets are in the same location and I would like the below code to play out for any combination of the 1-4 spreadsheets chosen.