Ok, I created a userform with three comboboxes. The drop down has all 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 is pulled into a new workbook (works pretty darn well, thanks in part to 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 for "ALL." So for instance, perhaps I want a state but instead of just green 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 goes wacky. If I put "ALL" in the combo box drop down, it replaces the column with "ALL" in the cells. Is there a way to do this, or must you pick a drop down/color etc.?

Does this make sense? Thanks.