Worksheet SelectionChange not working

Hi HJHamm,

Debugged the code works fine..Can you share the sample sheet for furthur testing?

HJHamm;4110559]I had this working and I have no idea what I did or what happened but now it will not work. When I drop the formula back into the Spreadsheet it works fine... So, it has to be some way in which I am calling the function improperly.

Hi HJHamm,

I thought I would point something out to you just to make sure you understand what's happening.

You have chosen the selectionchange event to fire your code. The selection change even fires when you select a cell other than the one that was already selected. You can do this by clicking on another cell or hitting enter which moves you to a different cell. Having said this I thought maybe what you were doing is something like what I am going to describe.

Let's say Cell A1 is selected and I click in your cell C2, the drop down list. As soon as I click in that cell the code fires, but you see no change because the drop down is the same as it was the last time the code was run. If I now simply change the value in the drop down but don't hit enter or click on another cell then the code doesn't fire so it appears as if what I have don't didn't do anything. If I change this cell and then click on K2 the other drop down I see a change from what I did with the first drop down and I think things are fine, but I click on the second drop down, the code fires, I change the second drop down but don't click on a cell outside the drop down or hit enter then nothing happens and I may think there's an issue and the code doesn't work, it works it just didn't fire because I have to actually leave the drop down to fire the code.

I don't know if this is what you were seeing or not but I just thought I would throw it out there, if this is not the issue maybe you could go into more detail.

Good Luck.