VBA to make a cell containing a dropdown list go blank when list selection changes in anot

Hello,

This is so overwhelming.

I have been using formula, =INDIRECT(SUBSTITUTE($B$11," ","_")&"(""COUPLING"""), which B1 represents the models as a drop down, and COUPLING was the name of a table which included all model names and measurements but was getting a #ref error message.

Is there anyway for a dropdown list for the models, and then another drop down list for the measurements that change if a model has changed too?

Your title is wrong - you do not need VBA to make any formula work.

I gave you a working formula in your previous thread, so why are you mentioning a non-working formula here?

The question here is about making a cell go blank when the option in a drop-down is changed. I am going to edit your thread title, as it's completely misleading.

I am also attaching my working solution for the benefit of anyone assisting.

This is the question you asked that needs answering here:

Is there anyway to get the measurement dropdown list to reset to blank after a new model has been changed?

This is the bit that I said would require VBA.

Hi Ali,

Thanks for the clarification. The helper column that you did worked a treat I just need some help with the VBA for the drop down on cell A6 to go blank once a new drop down on cell A5 has been changed

Yes - I know. Hopefully someone with VBA skills will step in.

Start by unmerging cell A6. You should avoid merging cells because they almost always cause problems for macros.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in A5.

Please Login or Register  to view this content.

It worked for me on the file you posted. It would be easier to help and test possible solutions if you could attach a copy of your actual file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

I thought I'd made it clear in post #2 which workbook was relevant to this question. Obviously not, so to avoid any further confusion, I have removed the attachment to post #1.

In the file you posted, when I selected "21' FAMILY VAN" in A5, the contents of A6 were deleted to make A6 blank. The macro is working for me. Did you put the macro in the worksheet code module as I described in Post #5?

You are very welcome.