We help IT Professionals succeed at work.
Get Started

Excel Macro Trigger creates Subset

Bright01 asked
Last Modified: 2015-06-25
I have a great outline interview Worksheet that EE Pro Martin Liss helped build.  This is a very solid WS that should help people who do interviews.   Right now, if you click the Outline button, it discloses different outline levels.  If you click the black Boxes in Col. C, you will get a cycle for a check, a question mark or an X.  Here is what I'm trying to do;

I would like to see, when you double click the black box, and the box shows a "Check" or "P" with Wingding2, it auto expands by one level.  If you click another box and there is a 3rd level, it will expand to the 3rd level. Click if so it doesn't show a Check (or "P") and it will contract back to the appropriate level.

Keep in mind, this list of questions/text will be at least in the neighborhood of 200+ rows when it is expanded.  You can use Column A as a designator since it equates to a specific "level."

Thank you in advance,

Watch Question
Social distance - Wear a mask - Don't touch your face - Wash your hands for 20 seconds
Most Valuable Expert 2017
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE