Macro to return the value of an identical cell location in another sheet?

Hi,

First of of all thanks to Tsjallie - was a great help on my last question. This question should be easier.

I'm looking for a macro that will return the cell contents of the identical cell location in another sheet.

Sheet 1 has the button to enable the macro, with the result box beside the button. The macro itself should wait for a mouse click (on cell J12, sheet 1 for example). Once the click registers, the macro should return the value of J12 on sheet2, in the results box (which is on sheet1). I know this is quite simple but I have absolutely zero software skills. Hoping someone can help!

Thanks

A cell would be fine

Thanks again - works a treat!

Originally Posted by :) Sixthsense :)

Change A5 to your desired Cell.

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.