I'm working on a concept to create an automatic clipboard, working from one sheet only.
First feature needed is to be able to set the tab order C7,C8,C9,C10,C11,C13,C16,C19,E7,E10,E13,G13,I13,E16,G16,I16,E19,C22 permanently regardless of whether any data is input into the existing cell. It should be possible to also click on a cell and when tab is pressed, it goes on to the next cell in this list following the selected cell. So for example, the user selects C13 and presses tab. It should then move on to C16.
Once the user is ready, code should start enabling a user to select any cell and automatically copy the contents to the clipboard. The user should be able to pause the code at any point to be able to paste data from elsewhere into the worksheet or type new data. I've added control buttons with the intention of those controlling start/stop.
At the moment, I have it working in part and have attached a copy so you can see what I am working with.
You will see that currently using tab messes up what is copied to the clipboard, clicking on a cell doesn't work as expected and for reasons I cannot fathom, it does not ever tab through to C22.
https://drive.google.com/file/d/1Pob...ew?usp=sharing
Thank you for your help.