Change active cell WHEN a specific cell value changes

Hey Gang

In cell M6 I have a CONCATENATE formula that returns a cell value like B300. I was looking for a way to automatically jump to the cell referenced in M6 whenever the value in M6 changes.

Is there a cell/cells that the user changes causing M6 to update that can be monitored?

Dom

Sorry will further modify the code
didnt notice that there is a formula in M6

Here you Go:
Paste this code in the Sheet's VBA code

Please Login or Register  to view this content.

Domski,

Yes. When the user chooses a number from a list in L6 the value in M6 is changed to reflect a cell in B:B

Kelshaer,

I am getting a Compile Error Ambiguous Name Detected after putting this in the sheet code. There is already sheet code in there with the same name. Can I simply add the code itself to the end of the other code that already exists?

well,
paste this in the beginning of your existing code or wherever you want to execute the othe macro.

Please Login or Register  to view this content.

then paste this below the existing code

Please Login or Register  to view this content.

As there is only cell L6 that will effect M6 you might as well just test that for changes.

Dom

Kelshaer

I did as you suggested in your last reply and nothing happens with the active cell after changing L6 which in turn changed the value in M6. Here is what the complete page code looks like.

Please Login or Register  to view this content.

I tried the code and it works perfectly.
Please try the attached file.

Kelshaer The attached file does work as expected. However when I put the code exactly as you have it in the sheet in my workbook it doesn't work. I don't see anything jumping out at me as to why it would work in one and not the other.....

here you go:

Please Login or Register  to view this content.

Kelshaer. I really appreciate the effort. The code works but in the live workbook it errors out when running some basic macros that are built into the book and when clearing multiple cells. I don't want to bother you to troublehsoot anything after the time you've already given me. Thanks.....

Ok. Use this instead and let me know the outcome

Please Login or Register  to view this content.

Kelshaer

Sorry I dropped out of this thread without a final reply. The last of the code has everything working as ecpected and all the help was greatly appreciated!