Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
Excel Macro Trigger creates Subset
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,
B.
Outline-Dropdown-Trigger.xlsm
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,
B.
Outline-Dropdown-Trigger.xlsm
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Can there be more than 3 levels?
And if I double-click cell C8
should it look like this?
Or like this?
And if I double-click cell C8
should it look like this?
Or like this?
YES. If you double click... you get only 1 level down as in your second example. If you click on the Sub Text A, you go to the next level..... but only if it's there.
B.
B.
Interesting Question. I thought that there may be given changing requirements. But this is actually a "tree" with 3 levels. Right now 3 levels is all there is. I'm trying to keep it simple.... but I leave the option open to add additional levels later..... So now.. let's stick with 3. Does that work?
B.
B.
Try this workbook. It has a new sheet called "Templates" that could be hidden.
28692258.xlsm
28692258.xlsm
Sorry about that. I was working with a copy of the "Architecture_Questions" sheet and modified the Toggle sub in that sheet. I deleted that sheet before I posted the workbook and so the modified code was also deleted. Try this version. Along with the Toggle sub changes I commented out a line in the BeforeDoubleClick event that was causing a problem.
28692258.xlsm
28692258.xlsm
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
Much better! Almost there.....
However, it should only trigger the outline subgroup if the box is "checked". Otherwise, it collapses the boxes back. In other words, the statements/questions (Green/Yellow) are only exposed if a check box in the top level (Blue) have been selected as "Checked".
So, when you clear the entire sheet, you will only see the blue boxes, unless you decide to trigger the "Display" Macro. Then you will see the entire sheet.
You nailed this one. I'm going to close this out and open another question to get the second half of this completed.
Thank you very much! And I hope you will pick up the follow on.
B.
However, it should only trigger the outline subgroup if the box is "checked". Otherwise, it collapses the boxes back. In other words, the statements/questions (Green/Yellow) are only exposed if a check box in the top level (Blue) have been selected as "Checked".
So, when you clear the entire sheet, you will only see the blue boxes, unless you decide to trigger the "Display" Macro. Then you will see the entire sheet.
You nailed this one. I'm going to close this out and open another question to get the second half of this completed.
Thank you very much! And I hope you will pick up the follow on.
B.
Nailed it!
I'm going to ask another Question given it should only trigger the outline subgroup if the box is "checked". Otherwise, it collapses the boxes back. In other words, the statements/questions (Green/Yellow) are only exposed if a check box in the top level (Blue) have been selected as "Checked".
So, when you clear the entire sheet, you will only see the blue boxes, unless you decide to trigger the "Display" Macro. Then you will see the entire sheet.
You nailed this one. I'm going to close this out and open another question to get the second half of this completed.
Thank you very much! And I hope you will pick up the follow on.
B.
I'm going to ask another Question given it should only trigger the outline subgroup if the box is "checked". Otherwise, it collapses the boxes back. In other words, the statements/questions (Green/Yellow) are only exposed if a check box in the top level (Blue) have been selected as "Checked".
So, when you clear the entire sheet, you will only see the blue boxes, unless you decide to trigger the "Display" Macro. Then you will see the entire sheet.
You nailed this one. I'm going to close this out and open another question to get the second half of this completed.
Thank you very much! And I hope you will pick up the follow on.
B.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel
From novice to tech pro — start learning today.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with premium.
Start your 7-day free trial.