Excel: Count The Number of UserForm ComboBoxes Which Contain Specific Text

Hello and thank you for any attention my post may receive. So I have an excel userform (UserForm1) with various controls and I would like to count the number of comboboxes (cbx) which contain the word 'Yes' and report the count in Label82 on the form. There are 24 cbx on UserForm1 and are numbered 1 - 24. To make this even more tricky I would like the CountIf to execute once TextBox57 is no longer empty. Is this possible? Thank you and have a great day!

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of March 06, 2017.

For more resources for Microsoft Excel