Multiple ComboBoxes - Is it possible to shorten code?

**ocnmel** · 01-06-2015, 09:40 AM

I have multiple ComboBoxes (some of the code is below) and I was wondering if there is a way to shorten it up?

Cross-posted here: http://www.mrexcel.com/forum/excel-q...rten-code.html

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**romperstomper** · 01-06-2015, 09:58 AM

Please use code tags.

Yes, you can do it in a loop:

Please Login or Register  to view this content.

**jindon** · 01-06-2015, 10:08 AM

Something like this

Please Login or Register  to view this content.

**ocnmel** · 01-06-2015, 11:18 AM

Thank you both for your time and assistance. It is greatly appreciated!

Re: Multiple ComboBoxes - Is it possible to shorten code?