Hello,
I have the following code that hides my row and Dependent combo box based on a Cell Value (E4); however, when my Primary Combo Box meets the requirements for Cell E4, my unhidden Dependent Box no longer shows the populated values. The Dependent Box works fine until it is hidden and unhidden.
Please help.
Please Login or Register to view this content.[/CODE]Please Login or Register to view this content.
Last edited by VinchinzoB; 04-13-2018 at 12:55 PM.
Deleted, User complied with request
Last edited by gmr4evr1; 04-13-2018 at 01:02 PM.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Deleted, User took care of the request.
Last edited by Arkadi; 04-13-2018 at 01:22 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hello Arkadi,
I've made the necessary changes and added a copy of the workbook.
@gmr4evr1, love the signature
VinchinzoB,
I don't understand the problem... if the dependent box is hidden (for example if we pick Butterfree), and then pick Charizard again, the dependent box is populated fine...
Picking Mewtwo does not populate the dependent box, but that is because there is no named range called Mewtwo so there are no items to add...
Can you explain in more detail what is wrong and how I can reproduce the problem?
Last edited by Arkadi; 04-13-2018 at 01:23 PM.
That's odd because when I choose Butterfree and then go back to Charizard, the dependent box is visible again, but the box is not populated. Would it have anything to do with me working on Excel 2016?
Yes the different Excel versions can behave differently, but it is pretty odd that something like this should be different on the 2 versions.... If you put a stop at "Set ws..." and then step through the code with F8 (when choosing Charizard after Butterfree), does it go through the code properly?
If that does not reveal anything, it may be worth, after choosing butterfree, to disable the On Error Resume Next, then choose Charizard and see if any errors come up.
I agree that it is weird this is acting different between the 2 versions. I placed a stop where you mentioned just before choosing Charizard again after Butterfree, but that didn't seem to populate the dependent box.
The stop was just so you could use F8 to follow each step, to make sure the code was running through the steps...
Potential workaround if the previous post does not help us find anything...
Comment out:
Go to developer tab, select design mode, right-click on the dependent list combobox, select format control, and on the Properties tab, select move and size with cells.Please Login or Register to view this content.
This will make it hide when you hide the row, but the box itself is actually not "hidden" just not visible because the height is 0. That way it is not hidden through code and may function better.
Another possibility is that something in the populating or unhiding is causing the event to trigger more than once... Start the sub with Application.EnableEvents = False (after Dim statements) and then at the end put it back to true (just before End Sub)
That worked perfectly! And because we just set to move and size with cells I was able to just remove the .Visible = True portion of the code as well. Still a little confused as to why the previous option was not able to work, but regardless. Thank you again!
My pleasure
Please remember to mark the thread as solved? Thanks!
@ Arkadi - Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks