Hi All,

I have been scuring the internet for solutions to my problem and reading as much as I can, but to no avail. I am rather new to vba so that is the main problem, but I have been able to create macros by writing bits and pieces or copying ones from the internet and pasting them in.

Having said that, my issue is that I have a range of cells, A79:A112 which are dropdown lists, which are the same drop down list for the entire range, and then I have a dependent dropdown list, C79:C112 based on the previous drop down selections.

When a user makes a selection in the first drop down, the corresponding depemndent dropdown has selections based on the first choice. I would like to have the ability to clear the dependent dropdown data when the user decides to change the first dropdown selection.

For example, a user may choose "Materials" from the first dropdown list in B79, and then a list of materials to pick from will be listed in the dependent dropdown in C79. Oftentimes however, the use wants to make a change and they select a different option in B79, yet the previosuly chosen selection in C79 continues to remain based on the previously selected Materials item.

I would like to be able to clear out the dependent dropdown list on any change to the first dropdown list to avoid confusion for the user, which currently happens.

In addition, I also have formulas that perform certain functions in the cell range C79:C112, in addition to the dependent drop down list. I would like to keep these formulas there as well without clearing them out.

Does anyone have any solutions to how I can accomplish this for each cel in the ranges I specified?