Combo box dependant on another combo box
Posted by Joe Librizzi on September 07, 2001 12:55 PM
Hello. I'm trying to make the choices appearing in one combo box dependant on what is choosen in a previous combo box (i.e. if the user chooses "California" in the first box, "Sacramento", "LA" and "San Diego" appear in the second. If he chooses "Texas", "Dallas", "Houston" and "Austin" appear). I've written a macro that assigns a range name to the appropriate list for each original choice. When I put the range name in the second combo box's input range, it tells me that it's "Reference is not valid".
If anyone has any ideas to get around this, I'd REALLY appreciate the help.