Clearing Dropdown content based on value of another dropdown

I have three dropdowns. Dropdown A, Dropdown B, and Dropdown C.

If a selection is made in Dropdown A, I would like Dropdown B and Dropdown C to select "No selection".

If a selection is made in Dropdown B, I would like Dropdown A and Dropdown C to select "No selection".

If a selection is made in Dropdown C, I would like Dropdown A and Dropdown B to select "No selection".

"No selection" is already built in to the Data Validation list.

Any help would be greatly appreciated. Thanks in advance.

Put this code in Sheet 1 - view code window -

Please Login or Register  to view this content.

Let me know if you have any questions.

Perhaps I'm going about it the wrong way to achieve my goal, but your suggestion didn't achieve what I'd like it to.

I've attached the file, so perhaps that might help me convey my issue.

The problem is that when a user selects a "Monthly" view and then selects a month, the calendar for that month will show. However, if a user then selects "Weekly" or "Daily" and makes a selection, the previous calendar month remains visible.

I think its due to the code thats written. I also observed that it does take pretty long to update, specially if you select Daily.

I was looking through your code and found it very lengthy. There should be a better way of writing it, so that excel calculates the dates itself instead of you typing in so much. In the following year, you will have to do it all over again which will be very time-consuming.

Maybe if you can provide the requirements, someone here can surely help you in making the tool as effective and productive as possible. (Overall, its a nice tool).

I'm all for doing things in a more efficient and effective way. The end goal for this tool is a program that will allow the user to view the activity of a Quality Assurance team. The user should be able to choose if they would like to view the Calendar in a monthly, weekly, or daily view.

Once the user has selected their preferred view and the date(s) they would like to view, only that information should be visible. That's why I chose to use the hide/unhide macro. If someone has a more efficient method, I'd love to see it. Unfortunately, I'm new to VBA so I'm trying to piece things together from other documents I've seen.

Can you please provide the requirements - for e.g. -
If the user selects monthly, he should be able to view rows ..to ... and the rest should be hidden.
If the user selects weekly, he should be able to view....

The dropdowns should reflect .....
etc.

If a user selects Monthly rows: 3 & 4 should be visible

Then if they choose January (10:17), February (540:546), March (1031:1037), April (1554:1560), May (2066:2072), June (2589:2595), July (3096:3102), August (3624:3630), September (4131:4138), October (4639:4645), November (5167:5173), December (5674:5681),

Weekly should be Rows 5 & 6.

Daily should be Rows 7 & 8.

Do you want the rows for the weeks and all the days?