Clear cell when drop down combobox is changed

[Dan]

Hi,
I have two comboboxes set up, one dependent on the other. I have been trying
to search for a solution to clear the 2nd one every time a choice is selected
in the first. I have learned and seen a lot of cool things trying to search
for this but still no luck clearing the 2nd combobox.

I would appreciate anyone's help with this!

Thank you,
-Dan

 

[Corey]

Do this in the ComboBox1 code like:

Private Sub ComboBox1_Change()
ComboBox2.value = ""
End Sub



Corey....

 

[Dan]

Thanks Corey - That did it! Knew it was something simple!