Various cells click to display that cells value in another cell, is a macro the way?

try this:

Please Login or Register  to view this content.

ok still having trouble, of course it is my faulty, (being so new to this) I added the VBA but can't get it to execute. I have attached my file for reference.

you had the code in a standard module and it needed to go on to sheet1. i fixed the code and it is working now.

Thats awesome! Thanks so much. For my own learning can you tell me what would make you place the code into a standard module versus being placed directly into the sheet I wanted to use it on? I suppose that if I wanted to place this in multiple sheets but in various locations on those multiple sheets, I would simply need to replicate the code and then adjust the cell references in the code accordingly? Thanks,Chris

Originally Posted by waternut

Thats awesome! Thanks so much. For my own learning can you tell me what would make you place the code into a standard module versus being placed directly into the sheet I wanted to use it on? I suppose that if I wanted to place this in multiple sheets but in various locations on those multiple sheets, I would simply need to replicate the code and then adjust the cell references in the code accordingly? Thanks,Chris

so yes, just put them on the various sheets and configure. as to whether you use a standard module vs sheet code is that mainly sheet code (and ThisWorkbook) is for events and standard modules are for sub (procedures) though subs can be anywhere.

so if this closes out the question, please mark the thread as sloved (thread tools at the top) and click on the Add Reputation in my post if your happy with the results.