• 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

Irelyn

New Member
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. :)
 

vletm

Excel Ninja
Irelyn
You asked Your thread in VBA Macros, then You would get as You asked.
Do Your used we mean some group there? If so, then of course You can do it.
 

Irelyn

New Member
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

Irelyn

New Member
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.
 

Irelyn

New Member
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 :)
 

Irelyn

New Member
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

vletm

Excel Ninja
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

Top