I have a Worksheet where I'm trying to modify a Macro that EE helped write some time ago.
What it does; You can select a designated cell next to a Statement/Question (the BLACK CELL), and double click, a macro fires that adds a check in the box. It's done by using Wingdings and a macro that recognizes the click and inserts the appropriate letter (P).
What I'm trying to do: I now need this capability in a multi-level (indented) List and wish to have the same capabilities across each identified Row. The way I have identified the active cell is by using a helper cell (in A) and using 1, 2 and 3 for different Offsets. I need help in modifying the macro to accomplishing this slight change. Specifically, if there is a 1, 2 or 3 in Column A, then the macro places the appropriate letter (P) in the correct Box (Black).
Thank you in advance. File Attached.