Rayne
asked on
Choices For DropDown
Hello All,
Please check the attached file for sample
I have a complex issue regarding dropdowns. I need three dropdowns (dependent). Can you suggest the best vba way to do this?
Quarter dropdown
Month dropdown
Week dropdown
For example:
1. if user selects Q1 for quarter dropdown, then he ONLY sees M1,M2,M3,M4 as choices for the month dropdown
2. Then, if user selects M1 for month dropdown, then he ONLY sees W1,W2,W3,W4 as choices for the week dropdown
What I am envisioning – is this possible within Excel’s architecture? Or I am overthinking :(
thank you
dropDownbreakDown.xlsm
Please check the attached file for sample
I have a complex issue regarding dropdowns. I need three dropdowns (dependent). Can you suggest the best vba way to do this?
Quarter dropdown
Month dropdown
Week dropdown
For example:
1. if user selects Q1 for quarter dropdown, then he ONLY sees M1,M2,M3,M4 as choices for the month dropdown
2. Then, if user selects M1 for month dropdown, then he ONLY sees W1,W2,W3,W4 as choices for the week dropdown
What I am envisioning – is this possible within Excel’s architecture? Or I am overthinking :(
thank you
dropDownbreakDown.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Paste the formula in any blank cell.
Select the cell
press F2...this will come to edit mode and will help you see the referred cells
with the edit mode active press F9 and you will see the result of the formula.
If you still have problems understanding then write back.
Select the cell
press F2...this will come to edit mode and will help you see the referred cells
with the edit mode active press F9 and you will see the result of the formula.
If you still have problems understanding then write back.
ASKER
Hello Ssaqibh,
Every-time you help me in EE, I always learn something NEW that I was not aware of :)
I never used those shortcut keys before. but now I will. Like here
https://www.experts-exchange.com/questions/27915756/Remeber-Save-the-last-breakpoints-Excel-VBA.html
I learnt 'STOP' and I have been using that extensively in coding since then
All thanks to you :)
I understood how you set up the logic. Took me a while to figure that as I didn't used offset formula for DV before.
Thank you
Every-time you help me in EE, I always learn something NEW that I was not aware of :)
I never used those shortcut keys before. but now I will. Like here
https://www.experts-exchange.com/questions/27915756/Remeber-Save-the-last-breakpoints-Excel-VBA.html
I learnt 'STOP' and I have been using that extensively in coding since then
All thanks to you :)
I understood how you set up the logic. Took me a while to figure that as I didn't used offset formula for DV before.
Thank you
ASKER
Unmatched BEST Expert Help as always.
ASKER
Ssaqibh,
New Question if you are interested :)
https://www.experts-exchange.com/questions/28002237/Remove-Dropdown-Space.html
New Question if you are interested :)
https://www.experts-exchange.com/questions/28002237/Remove-Dropdown-Space.html
ASKER
Hello Syed,
I remembered that you helped me with this complex one last time :)
I have another new question -
https://www.experts-exchange.com/questions/28387216/dependent-this.html?anchorAnswerId=39925376#a39925376
Rayne
I remembered that you helped me with this complex one last time :)
I have another new question -
https://www.experts-exchange.com/questions/28387216/dependent-this.html?anchorAnswerId=39925376#a39925376
Rayne
ASKER
You have proved from time to time that:
The best solution is always the most simplest one
(and I was thinking 100 lines of VB code :(
Can you exaplin whats happening here for the two drop-downs
month dropdown =OFFSET($L$7:$O$10,MATCH($
week dropdown = =OFFSET($L$10,MATCH($C$3,$
thank you :)