Search as you type in a textbox: need to filter Dynamically created checkboxes)

On userform activate i add a list of dynamically created checkboxes from a range list in the sheet. what i want to do is...to have a textbox which is able to filter the checkboxes based on captions or name

for example as i type in the textbox the suggested matches should be filtered to a list (or listbox) so that the user can check mark it instead of going throuhg the long list..
please help

Rather than creating text boxes at run time, you could use a Multi-Select ListBox with the ListStyle set to Option.

I'm not sure where you are getting the captions for you checkboxes. This code has a UDF that creates an array of all the possible options.
There is code that then filters that depending on the text box entry.

Please Login or Register  to view this content.

hbhbfgdngdngfndfgnhgfhfd