I'm not really sure what is happeing. I'm trying to build a list in column g using formulas, then I only want certain answers left. It seems that code is circular for some reason. I thought it might be due to a linked cell to a combobox but I changed the link to a cell on a different sheet and it still caused problems. My Excel keeps blowing up everytime I try to run it. I've attached an example. Try changing the value in the combobox and see what happens.
Code is a circular ref???
-
-
-
Re: Code is a circular ref???
Your attachment gave me a fatal error in Excel when I made a selection in the combobox.
I'll maybe try it again later.
-
Re: Code is a circular ref???
Hi Could You Explain What Does Your Routine Acheives?
-
Re: Code is a circular ref???
What I'm trying to accomplish is when I choose a manufacturer from the list in the combo box, I want to create a list of descriptions (i.e. roadster,coupe,sedan) that will become the list for another combobox. When nothing is chosen, however, I want the full list of descriptions to be there. You'll notice in the example, on the sheet named List, Dodge only has SUV, Super Car, Full-size Pickup, and Muscle Car as possible descriptions associated with it. So, if Dodge was chosen in the combo box, those four choices would compile the list for a different combo box.
-
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!