Userform One or more options listbox? combobox?

**starcraftbud** · 08-24-2010, 04:58 PM

Hello,

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.

Please Login or Register  to view this content.

**royUK** · 08-25-2010, 01:58 AM

This example can easily be adapted for your needs.

SheetsToPrint.zip

**starcraftbud** · 08-25-2010, 09:50 AM

Thank you for responding Roy. My company's annoyingly overprotective site blocker is not allowing me to access the link.

Is there another source or example you know of that can also apply? Or can the sheet be posted as .xls rather than a zip file?

**starcraftbud** · 08-25-2010, 11:44 AM

Roy, no need to respond. I think I've figured out a way how to do it.

The userform options simply put a value in a cell. I then use these values to determine which selections the user chose and respond accordingly. I'll mark this thread as solved once I verify this works for me.