compare values and msg box for permutation

[SarahPintal]

Hi guys,

I hope someone can help..

I need a macro that will check if the word in column J5, J6, J7. (what ever cell has been changed in column J) is the same or differnt that the one in column A on the same row.

If differnt then for a specific msg to pop up to each permuation.

column A has a drop down list with 3 names, and column J has that same drop down list with the same 3 names.

I want to be able to have a msg box pop up is in column A5 (for example) the work sarah is entered and in J5 the worked Mary is entered, for the msg box to say "mary is Sarahs mum" ... if Mary is in A6 and Sarah is in J6 upon selecting Sarah a msg box would this say "Mary is Sarahs mum"..

The words are Sarah, Mary, John

Is that possible... ? thanks guys

[SarahPintal]

I tried this for an initial tester - see the KeyCellsChanged sub..... nothing happens though.

Please Login or Register  to view this content.

[SarahPintal]

Okay so this works, though it would be great if someone couple please assist with helping me make it so that if any cell K:K is changed then for the below sub to be called.

please help, thank you , S

Please Login or Register  to view this content.

[SarahPintal]

well it seems that silence has solved this.

I worked it out, this is what I did for anyone that wants to know;
This is 1 the worksheets code:

Please Login or Register  to view this content.

and this is in module 1

Please Login or Register  to view this content.