VBA Filter combobox on userform with search suggestions

[MarcelCleijsen]

Dear all,

I have created an excel userform with some comboboxes, attached a document with the problem but stripped down to the basic problem.

I figured out how i can filter/autoupdate my comboboxes and decrease the input list while i start typing in the list. However as soon as i select an item i get the following error: "Unable to get the CurrentRegion property of the Range class".

Since i want to apply this feature to all comboboxes on my userforms i have put everything in a class event.

I have already found some stuff online but these were basically comboboxes on a worksheet.

Thank you very much!

Best Regards, Marcel

combobox_filter.xlsm

Please Login or Register  to view this content.

[MarcelCleijsen]

Dear all,

Does anyone have any clue regarding this subject?

Best Regards, Marcel

[MarcelCleijsen]

Dear all,

I still wasn't able to figure this out?

Anyone a clue?