J
JonathanK1
Ok, I created a userform with three comboboxes. The drop down has al
of the data I need it to (from another tab), such as states, colors
etc. It's set up so when you click on state, color etc. this data i
pulled into a new workbook (works pretty darn well, thanks in part t
you folks).
Right now it looks like this:
Range ("H:H").Value = Combox1.Text
Range ("C:C").Value = Combox2.Text
Range ("M:M").Value = Combox2.Text
The problem is that in combobox for each of these I have an option fo
"ALL." So for instance, perhaps I want a state but instead of just gree
or purple, I want all the colors instead of having to narrow it down.
However, if I leave it blank adn don't answer that question, it goe
wacky. If I put "ALL" in the combo box drop down, it replaces th
column with "ALL" in the cells. Is there a way to do this, or must yo
pick a drop down/color etc.?
Does this make sense? Thanks
of the data I need it to (from another tab), such as states, colors
etc. It's set up so when you click on state, color etc. this data i
pulled into a new workbook (works pretty darn well, thanks in part t
you folks).
Right now it looks like this:
Range ("H:H").Value = Combox1.Text
Range ("C:C").Value = Combox2.Text
Range ("M:M").Value = Combox2.Text
The problem is that in combobox for each of these I have an option fo
"ALL." So for instance, perhaps I want a state but instead of just gree
or purple, I want all the colors instead of having to narrow it down.
However, if I leave it blank adn don't answer that question, it goe
wacky. If I put "ALL" in the combo box drop down, it replaces th
column with "ALL" in the cells. Is there a way to do this, or must yo
pick a drop down/color etc.?
Does this make sense? Thanks