Clear cell when another changes

Hi,

I have never used VB before and have no real understanding of it, but I believe I need it to solve my problem.

Column E has a drop down list in every cell. Column F then has drop down list dependent on what you select in column E.

I would like to be able to have the cell in column F clear if column E is changed.
ie Change cell E8, then F8 will clear,

this would happen for all the cells from E6:E505

Hope that makes sense.

Any help in baby steps and language would be really appreciated.

Thank so much

C

Thanks so much for your reply.

I'm using Excel for Mac 2011 so went into the developer tab, clicked on editor, discovered there are 2 folders both identical called VBA project. I clicked on the worksheet I wanted, pasted the code, clicked the save icon, closed it all and tried the worksheet. Nothing happens.

Went back in and pasted the code into the identical worksheet bit under the other VBA project folder. Still nothing works.

No idea what I'm doing wrong!

Thanks, but that definitely doesn't work. I deleted the code as you said, but when I right click on the worksheet or the worksheet tab there is no option to view code.

I tried googling it and it says for Excel on a Mac you have to go to Tools>Macro>Visual Basic Editor which simply takes me back to the same place I've just been to delete the code.

OK, I've done this basic one to show what I need.

Basically I have two drop down lists (2nd one is dependent on 1st). I simply want it so if somebody changes their selection in the first column, it clears their previous selection in the second column.

I want this to apply all the way down the column so if they change a selection on any row in column E, it will clear the selection on the same row in column F.

(Obviously in my example sheet i've just put the boxes in A and B and only on one row).

Thanks for your quick responses, I clicked on your file and said enable macros.

I then selected "Veg" in the first column and "Red" in the 2nd. When I go back and change veg to fruit, the Red remains there and doesn't clear. Does this mean maybe something isn't activated on my version of Excel which is why none of these things are working?

It says False when I hit enter.

I went to the immediate window again and entered the code,

It comes up with an error that says Compile Error: Invalid Use of property.

Sorry for the hassle!

Thank you, that now seems to work.

I have only one other question,

When you change the cell in the first column, it does clear the 2nd column, but it then puts a selection box around it but leaves the little drop down box arrow from the first column. Is there a way to either make it show the drop down box icon for the second column instead or not put the selection box around the 2nd column cell?

If that doesn't make sense I'll post an image!

Hi,

Did that and it's seems to have gone really wrong now.

As soon as I tried it, it said Runtime Error 1004, Command not available in Excel for Macintosh.

After that the blanking doesn't work at all.

Sorry!!

Thanks so much for trying again, I really appreciate it. Unfortunately that one doesn't work at all either.

The great shame is it would be perfect with the original thing you wrote for me if it weren't for the weird highlighted cell thing it does. Ie if I change a cell in column B and hit enter, the drop down arrows appear to the right of the cell below like they should, but the selection/highlighted box is around the cell in column c on the row above (i.e. the one the macro just blanked).

Ah well, I can live with it and it works, so I won't waste anymore of your time.

Many thanks

c