How to clear two comboboxes that depend on each other values.

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?

Hi,

Inside the ComboBox1_Change() subroutine, try adding this before any of your existing code:

Please Login or Register  to view this content.

Hope this helps

Call me an Idiot.

Thank you so much!

Hahaha no worries!

Please don't forget to mark this thread as solved and please click on the * next to my post to say thanks