Hello,
I'm trying to create a macro in Excel VBA that will change the active sheet and cell whenever a particular cell is clicked in the current sheet. I currently have that working with no problems (see below).
As the above code lays out, when the user clicks on cell A4, cell A1 on sheet "Charts" becomes the active cell. My issue is that if the user clicks in cell A11, I want it to activate cell A28 on the Charts sheet; If the user clicks in cell A30, I want it to activate cell A50 on the Charts sheet...and so on. I could use the above code and just add another case for each instance, but that seems long and cumbersome and I feel like there's a better way. Let me know if you need more information. I appreciate all of your help. Thank you!
Bookmarks