Need Help with Mapping ONLY
OK..... I have a question on EE that combines a mapping capability using helper cells and a click rotation for different characters. I think it might be better to break this into two questions. So here is the ask.
Can you take a look at how I would Map a Character, say a "P" into cells corresponding with the "1" in the Helper cells?
I'll follow up with a question later, after testing, on the toggle portion.
Much thanks in advance.
B.
Map-Checkmark-on-Click-in-BOX.xlsm
Can you take a look at how I would Map a Character, say a "P" into cells corresponding with the "1" in the Helper cells?
I'll follow up with a question later, after testing, on the toggle portion.
Much thanks in advance.
B.
Map-Checkmark-on-Click-in-BOX.xlsm
Martin Liss
Please describe in more detail what you want to have happen. Also in your code, what is "Toggle"?
ASKER
Hi Martin, Thank you for the reply.
Please ignore my code. It was an attempt to try to do what I'm trying to have done.
Here's the situation. I'm putting together a "Strategy Map" and want to have a macro, that when you double click on it, it checks the Table (HELPER CELLS FOR BOX TARGET) and if there is a 1 in that particular Column/Row (associated with an "Area"), it will place the specific Letter that is in the appropriate clicked on box.
The Toggle requirement will be in a second question where the specific LETTER in the HELP CELLS TOGGLE CHARACTERS, will be cycled through as you click on the specific Boxes.
Does that make sense?
B.
Please ignore my code. It was an attempt to try to do what I'm trying to have done.
Here's the situation. I'm putting together a "Strategy Map" and want to have a macro, that when you double click on it, it checks the Table (HELPER CELLS FOR BOX TARGET) and if there is a 1 in that particular Column/Row (associated with an "Area"), it will place the specific Letter that is in the appropriate clicked on box.
The Toggle requirement will be in a second question where the specific LETTER in the HELP CELLS TOGGLE CHARACTERS, will be cycled through as you click on the specific Boxes.
Does that make sense?
B.
ASKER
Sorry Martin.... not when you click on the Macro, when you click within the cell that represents each box.
B.
B.
I understand that but please tell me something like "when I click on cell "I12" I expect that...
Also I asked about "Toggle" because if you double-click on a cell like "I12", you get an error involving "Toggle", and that's why I asked what "Toggle" was?
Also I asked about "Toggle" because if you double-click on a cell like "I12", you get an error involving "Toggle", and that's why I asked what "Toggle" was?
ASKER
Fair enough. If you doubleclick on I12, since I12 is in Area 1, the Macro needs to look at Area 1 in the Table which would be A12 and if there is a "1" in A12, it places the first letter that is in Area 1 Helper Cells Toggle Characters, which would be A25 which would be the Character "P". If there is not a "1" in A12, it leaves it blank.
Just for a heads up, the 2nd question I will be asking is that when you again double click in I12, it will cycle through the character in the Helper Cells Toggle Characters column associated with the Area. So in the Case of Area 1, I12, an additional double click would take it back to blank or null. In Area 2 it would cycle through B25:B32.
Hope that helps.
B.
Just for a heads up, the 2nd question I will be asking is that when you again double click in I12, it will cycle through the character in the Helper Cells Toggle Characters column associated with the Area. So in the Case of Area 1, I12, an additional double click would take it back to blank or null. In Area 2 it would cycle through B25:B32.
Hope that helps.
B.
ASKER
In the future, I need to provide more detail. Sorry about that.
B.
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Martin, Thank you very much! Works great and you fixed/answered both questions. Can you also respond to the other one I have outstanding so I can close it with you as well?
Hope all is well with you.
B.
Hope all is well with you.
B.
Please supply the URL.