Clear ALL combo Box

Hi,

How do I clear all combobox at one time?

Now i am clearing it one by one and i forsee that if i have alot of combobox, this list will go a long way..

Please Login or Register  to view this content.

Hello jieyi,

This macro will clear all ComboBoxes (Control Toolbox type) on the active sheet provided you haven't changed the name from "ComboBox" and they are not loaded using the ListFillRange property.

Please Login or Register  to view this content.

Here is another spin on the same method. This assumes that you have named your controls in a defined manner such as: lstMyList_1, lstMyList_2, etc..

Please Login or Register  to view this content.

And you can combine this method and the one above as follows:

Please Login or Register  to view this content.

You need to check the first 14 characters of the name for a match

Please Login or Register  to view this content.

Hello jieyi,

This is similar to Andy's suggestion. Instead of using the Left string operator, the LIke operator is used to do a partial match. This approach offers more flexibility for comparisons.

Please Login or Register  to view this content.