• 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.

When one of the dropdown list is in YES, the rest will set automatically as NO

Irelyn

New Member
Hello Macro Guru,

Can someone help me on how to do this scenario?
How to set the rest of dropdown into No if one of that dropdown is selected as Yes?

Hope you can help me. Thank you in advance.
 

Attachments

  • Validation.xlsx
    8.7 KB · Views: 5
Wow this is nice.. I was expecting that when Yes is selected the rest will just set as No manually.
This one is great that whenever the Yes is selected the other will turn into No automatically.
Thank you so much @vletm for helping me on this. :)
 
Hi @vletm yes actually I want to use VBA Macros on this however when I tried to do it in my working file, the changing of Yes into No seems not working well. Sorry for the confusion, I used the word we not for some group here, I used it as You and I.
If it is not too much to ask, can you check my VBA scripts as I know there is something wrong. Thank you in advance.
 

Attachments

  • Project DRAFT Sample.xlsm
    51.7 KB · Views: 2
Basically the validation should be when I select Yes in one of the Financial Management simple, medium or complex the other 2 will set to No. Same validation to when I select Yes to Dunning simple or medium only one should be in yes and also in Advanced Order Management SIMPLE or Medium.
 
Hi @vletm ,

Thank you so much this is perfect! You have solved my problem :).
Thank you for taking time to correct the scripts in my file. Thanks a lot :)
 
Hi @vletm ,

I would like to ask on how I can hide and unhide the rows in a locked sheet? I have attached again the file the we use before and the only problem now is that whenever I tried to locked the sheet, the hiding ang unhiding of rows for AMO Package is not working anymore. The password is 123. Appreciate your help again on this. Thank you in advance.

Best Regards,
Ivy
 

Attachments

  • Project DRAFT Sample (2).xlsm
    51.8 KB · Views: 8
Irelyn
With which setting did You try to lock?
If You would like to hide row then there should be allow to [un]hide rows.
I added that missing functionality.
Hint: Those Sheet1's cells should unlocked, which users needs to use. If users can ... do what ever ... then user would do so.
 

Attachments

  • Project DRAFT Sample (2).xlsm
    53.2 KB · Views: 9
Hi @vletm

Good Day!

I would like to ask for help again with the attached file.

How can I make the column H and column M having the same logic in column C?

Logic in column C is:
those with colors should only select one Yes and the other will automatically set to No.

I hope you can help me again on this. Thank you in advance.

Best Regards,
Ivy
 

Attachments

  • Sample File.xlsm
    65.1 KB · Views: 2
Hi @vletm,

That one is amazing! I think I can also use that logic for future reference. But what I want is to have the same logic in column C to be apply as well in column H and column M.

Example:

In column C, the row 7 and 8 will only chose 1 yes.
If I select Yes in row 7, the row 8 should stay as No and vice versa.
This logic should also apply in row 13&14, 15&16, 17&18, 19&20, 65-67, 68-69, 71-73

I have attach the file that I added some formula but I don't know what I am missing.

Again thank you in advance for helping me on this.
 

Attachments

  • Sample File2.xlsm
    66.2 KB · Views: 1
Irelyn
You missed totally my made code.
Your #13 reply file has two groups of row to take-care.
... others were maybe hidden or so.
You can see my code and add those missing row-groups.
 
Hi @vletm ,

I tried your code and added those missing row-groups and it is working now.
However, there are some issues occurred like:
* column C rows 9-12, and column H rows 17-18, these rows can all select Yes and should not auto change the other cell to No.
* column M rows 6-7, these rows cannot auto select No when selecting yes

can you help with this?
 

Attachments

  • Sample File3.xlsm
    66.5 KB · Views: 1
Irelyn
Do those three columns C, H & M have different 'row-groups' for those "yes/no" -rules?
If so, then I should know - what are those?
or
You should get an idea - what have You done? ... what You should do?
Just now - that code do not work ... well! .
.. or actually as every code, it'll work as it has written.
 
Hi @vletm

Yes those three columns C,H, & M has different row-groups for the "yes/no".
In the sample file3.xlsm that I have attached, I put different color on every row-group (col. B,G & L) that should be select only 1 "yes" and automatically set the other into "no".

I have also attached notepad of the row-group for the "yes/no" per column for your reference.
 

Attachments

  • Sample File3.xlsm
    66.5 KB · Views: 3
  • Columns row-grouping.txt
    2 KB · Views: 2
Hi @vletm

I already got the correct formula using your 1st example. Thank you so much again for your time helping me on this.

Best Regards,
Ivy
 
Back
Top