Combo Boxes

[Roddboyd]

I have more than 150 combo boxes. Is there a way of setting up a code to scroll within all combo boxes in one formula.

[Leith Ross]

Hello Roddboyd,

Your information is not very complete. If you have a workbook, you should post it.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[Roddboyd]

To be a little clearer in combo box 1 you can select and scroll within that box. The
code relates combo box 1. However, you will cannot scroll within box 2,3 etc.

Is there a code that can be written to encompass all combo boxes.

Thanks for your help.

Rodney

[Leith Ross]

Hello Rodney ,

There are 2 ways I would approach handling this. First, I would opt to use a UserForm as the user interface and transfer the combobox selections to the worksheet. You would only need 3 on the UserForm. 150 ComboBoxes is a lot of duplication for only 3 combox choices.

Second, if you really, really want to keep all those boxes then the controls would need to be Sub-Classed. This would allow the same code to be shared by all 150 ComboBoxes.