Hi. I am creating a quiz for a foreign language and I have a command button which is set to randomly pick a specific word from a list in another sheet. I also have 3 dependent drop down lists linked together. So that when I select something in the 1st drop down list, what I have selected will affect what appears in the 2nd. And what I select in the 2nd drop down list will affect what appears in the 3rd. And if I select the correct options in those 3 drop down lists, the answer for that foreign word will appear in the following cell as either "correct" or "wrong". Then when I click the command button to generate a new word, the word gets changed, but the options I previously selected in the drop down lists still remains. What I am trying to achieve is that when I click the button to generate a new word, those drop down lists clear, ready for me to evaluate the next word. But I don't know how I would change the VBA code accordingly. Any one have an idea?
Bookmarks