Conditonal DropDown with IF condition

Hi Experts,

This is my first post and before posting, I have searched the whole forum for this issue.

The issue is as follows:

Suppose A2 cell has value as "Yes" or "yes".
So if A2 = "Yes" then
B2 will have a drop down list of "Yes" and "No", so that user can select yes or no from the Drop-down list.
But if the A2 cell has any values other than Yes/yes then
B2 will show "N/A"

Current workaround is:

Please Login or Register  to view this content.

Please help regarding the issue.

Regards,
Sap.

hi, saps19, VB option, try to change A2 cell value

grey out added, please check attachment, please specify what should be protected and when?

Originally Posted by watersev

grey out added, please check attachment, please specify what should be protected and when?

Thanks Water... I have already modified the code, please check below.

Please Login or Register  to view this content.

But this code works for only one cell. I want to run this macro in all the cells.

Please find the attached excel sheet for details.
According to "Worked?" option, the "Availed?" option will change.

Please Login or Register  to view this content.

please check attachment

Originally Posted by watersev

please check attachment

Thanks for the help water... Now I'm able to run macro in alternate cells(Like A1, A4, A7 etc). Please find the below code and suggest if it needs any further modification / improvement.

Please Login or Register  to view this content.

However, I need to achieve the following two points:
1. I don't want to run this macro after 10th row.
2. The macro should start from my desired location(i.e: Suppose from B5 or C4 etc.).

Please help me with this two point.

Cheers,
Sap.

please check attachment, the code will work in any column if target (changed cell) is within 1:10 rows including

Originally Posted by watersev

please check attachment, the code will work in any column if target (changed cell) is within 1:10 rows including

Thanks water... I tried to modify the codes. I have attached the excel sheet with some points.

I want to run the macro in "Worked?" column only; the values in "Last date" and "Used date" will vary depend on the value of "Availed"(Yes/No) column. There will be a date calculation like this: =DATE(YEAR(C1),MONTH(C1), DAY(C1)+90) in "Last date" column. "Used date" column will have manual entry if "Availed" column has the value as "Yes", otherwise "Used Date" column will contain "N/A".

Please help me with it accordingly.

Cheers,
Sap.