• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

List box with restrictions based on user inputs. [SOLVED]

Sammy

Sammy

New Member
Hello Champs,


I have 3 list boxes (to select Country, State, District) linked to each other. Under “country list box”, I have a list of country names and when one gets selected it shows corresponding states under “state list box”. State list box also has a list of states which upon selecting one will display the district names under “district list box”. So basically I first select country, then state then the district.


What I would like to do now is have some restrictions based on the country/state/district the user id belongs to. For e.g. a person based in India shouldn’t be able to view anything under Sri Lanka/Nepal basis the user id the user provides while opening the file or better see only India in the "country list box". So now once the user selects India, they should again be able to see only the states they are supposed to view in the “states list box” and so on with the “district list box” too. Admin will have unrestricted access.


I’ve been trying to crack this for the past few day but unsuccessful so far. Any help with formula’s or vba would be much appreciated.


Thanks,

Sammy
 
Good day Sammy


Indirect data validation is the way to go, this is probably one of the better sites to learn and understand it.


http://www.contextures.com/xlDataVal01.html
 
Well bobhc, the problem is I have lots of users accessing this dashboard with different restriction levels across different locations. Of course I can use the data validation option, but isn't there any other options in using the list boxes?
 
Hi, Sammy!

Does this help?

http://chandoo.org/forums/topic/data-validation-list-automatically-shows-the-first-item-in-the-list

Regards!
 
I guess I'll just have to go with data validation instead of list boxes. Thanks to you both bobhc & SirJB7 for looking into this!


Regards,

Sammy
 
Hi, Sammy!

One thing that you could do but involves VBA code is loading the list box controls by a macro in which you may filter which elements are going to be included for that user.

Regards!
 
Finally figured it out. Had to do a lot of indirect lobbing from here to there and from there to here and so on. My worksheet is like the aftermath of a war now :)
 
Hi, Sammy!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!

PS: Maybe you want to share your solution with the community, so as people who read this would have the issue or question and the solution or answer as well.
 
Sorry, been out for a couple of days and saw your post only today. I've uploaded a sample in the link below. As i said before, it's all messy as i haven't done any clean up :)


http://rapidshare.com/files/3366986634/Test.xlsx


Thanks,

Sammy
 
You must log in or register to reply here.
Back
Top