Drop Down List with Conditioning/Validation
Hi all , my boss askes me to create a form for addition and deletion of users from a system. I can do the drop list but not the validation part, hence I need some help fr kind souls. This is an example of the requirements.
Column A: 3 types of user groups 1)APAC 2)ED 3)POP (DROP DOWN LIST)
Column B:
If 1)APAC is selected in Column A, display 3 choices 1)Creator 2)Inquirer 3)Verifier (DROP DOWN LIST) in Column B
If 2)ED is selected in Column A, display 2 choices 1)Creator 2)Verifier (DROP DOWN LIST in Column B
If 3)POP is selected in Column A, display 1)Inquirer 2)Security Administrator (DROP DOWN LIST in Column B
Your kind assistance will be much appreciated, thank you very much!
Hello yocin,
I am providing you with a link to site that has step by step instructions on how to do what you want.
http://www.contextures.com/xlDataVal02.html
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
in column B, validate the cell as list, choose the data range to be, may be Range(ax1:ax3)
if column A cell = 1) ax1= creator, ax2=inquirer, ax3= verifier
if column A cell =2) ax1=.............ax2=..........ax3=........
if column a cell = 3)..............................
is this what you want
Hi yocin
Attached is an example of what one can do with a user form and validation. If you wish to pursue this approach it can be be adapted to meet your needs.
If you need assistance in pursuing this, please define your requirements.
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi yocin
You ask if you can post another question. If it's related to this issue, post away. If it's a new issue, a new thread would be appropriate.
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks