I have ranges that are named Math, Reading, Science. I would like to create a drop down list in validation that chooses the range based on a value in a particular cell.
This formula does not work in validation. Is there a way to do this and retain compatibility with the MacIntosh platform?
Please Login or Register to view this content.
Veronica
Last edited by vjboaz; 10-14-2008 at 05:00 PM.
Hello vjboaz,
I have attached a sample of using a two validation drop downs. The first will show the subject science, reading, or math. The second drop down will look at the contents of that cell and then load the second drop down with the classes for that subject. This only requires that you name your ranges.
Sincerely,
Leith Ross
This works absolutely beautifully. I think I may be a little dense. How do I duplicate it, I could only find this VBA code in the workbook:
Please Login or Register to view this content.
How do I duplicate your drop downs? I can't see how to set them the way you have. Sorry to not get it...
Thanks.
Veronica
Hello vjboaz,
Sorry about the VBA code. That was a answer to another post. Forgot to remove it. The worksheet uses only validation drop downs and named ranges. Click on the drop down > Data > Validation... to see the references to the named ranges.
Sincerely,
Leith Ross
Thanks so much... it was the reference code that kind of confused me.
It works perfectly.
Veronica
6 years ago! I hope you're still reading these! I'm so close to getting this right on my own spreadsheet, but when I create the list and input the source =INDIRECT(ListName), I get an error: "The Source currently evaluates to an error. Do you want to continue?" Can you help me fix this?
ameyzing1
ameyzing1,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks