Hi!

Just like in the topic:
I have a problem with macro that clears the values of two comboboxes.
Unfortunately there is always an error which says that "The value was nat found"
Let me explain why:
When I choose a value in combobox1 the value of combobox2 depends on the value of the first one(I use combobox_change subs). The same is with the second combobox.
When I clear combobox1 an error occurs that in the combobox2 there was no matching data. The code breaks and doesn't allow me to clear the second one.
VBA doesn't allow to clear both comboboxes at once.

Can I ask you for help?