VBA for Double Click Copy Paste

Hi,

I think this one is fairly simple but I've had a hard time getting the code to be as basic as possible. I need a VBA code that will allow me to copy and paste a value into cell A1 by double clicking the desired value.

The desired value will always be in Column A (A2:A300), and the goal is that when I double click a value within that column, it will be copy and pasted into cell A1. The value will also always be a number.

Any help is appreciated.

Thank you.

Maybe:

Please Login or Register  to view this content.