Macro to switch two cells value

I need macro that will basically store contents of cell once selected and on next selection store contents of that cell then paste the cell info from first selected cell into the second selected cell and the info from the second selected cell into the first then turn this feature off until active again

Coding so far

Please Login or Register  to view this content.

edit: fix code brackets

Hello Meabrams,

you can try this:

Please Login or Register  to view this content.

Is there a way to have this without the input box

Code in normal module :

Please Login or Register  to view this content.

Code in sheet module :

Please Login or Register  to view this content.

You need to call Sub Switcher_Start() everytime you want to do the switch (you can assign a keyboard shortcut to this sub if you use it a lot).

Works like a champ thank you

You are welcome, glad to help.


Regards