Avatar of Bright01
Bright01
Flag for United States of America asked on

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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

Please describe in more detail what you want to have happen. Also in your code, what is "Toggle"?
Bright01

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.
Bright01

ASKER
Sorry Martin.... not when you click on the Macro, when you click within the cell that represents each box.

B.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Martin Liss

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?
Bright01

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.
Bright01

ASKER
In the future, I need to provide more detail.  Sorry about that.

B.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Bright01

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.
Martin Liss

Please supply the URL.