I was experimenting with dependant dropdowns using the indirect command within data validation when I found that on a Mac it works for a second dropdown but not the third one. What have I done wrong?
I was experimenting with dependant dropdowns using the indirect command within data validation when I found that on a Mac it works for a second dropdown but not the third one. What have I done wrong?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
the third dropbox Named Range coincide with Ordinary Cell address, so it is in conflict.
see the "new" data validation source of combo3.
Last edited by arnelgp; 07-25-2022 at 12:18 AM.
Yes you were right. I have deleted all the named ranges, created new data, name ranges and bingo, there she blows
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Well, FWIW I'm not sure that was the original problem (I'm on Win 10)
I think there was some inconsistency between the Names and the DV values
1. Many Names had _ suffix but the DV pick list did not
Capture2.JPG
2. You were missing the INDIRECT() I think
Capture.JPG
3. "Sun Valley" in E13 text had no _, but Name does
Capture3.JPG
4. List of Names
Capture4.JPG
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thank you Paul. Yes I also noticed that in Name Manager. Some of the named Ranges had the _ symbol at the end of the names so I simply deleted those and reconfigured the named range. And Yes I also screwed up the Indirect() within Data Validation. I was on this sort of logical roundabout that I couldn't get off. Maybe If I had simply walked away, cleared my mind and then come back to the issue I probably would have found it. I had a one way ticket to "Frustration Central"
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Even less obvious was the underscore between Sun_Valley in Names, but not in the data
BTW, I do like the use of INDIRECT() that way. Never would have thought of that, but should be useful
Last edited by Paul_Hossler; 07-26-2022 at 01:57 PM.
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
I found an example of indirect() on a internet search
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link