Clear cell when drop down combobox is changed
 

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

Clear cell when drop down combobox is changed
 

Do this in the ComboBox1 code like:

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



Corey....

"Dan" wrote in message
...
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

Clear cell when drop down combobox is changed
 

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



"Corey" wrote:

Do this in the ComboBox1 code like:

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



Corey....

"Dan" wrote in message
...
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