I have 1 list box as tree view and i want to show this list box in all sheet.
the issue is, when I select any value in this list box in sheet1, I want the same list and selected value as expended should show in sheet 2.
but the issue is in sheet 2 it showed like: not same expended like image 1.
Maybe you need to expand your listbox and then save the document.
right mouse click into listbox --> then click: Expand all --> save the qvw
hope this helps
no, still the response is the same .
I need when I expand and collapse the list box, same should happen in list box available in other sheets.
i want to use this list box as the sheet navigation bar and should be responsive.
but when i expand the list box in sheet 1 , list box in sheet 2 with same object id does not change responsive.
please suggest if we can do something by action/trigger or by macro code.
what happens if you push the + sign in front of DeliveryHead.
if i do this, the listbox on the other sheet adapts automatically!
can you show me how it's possible?
i am selecting Chairman-->CEO-->DeliveryHead in sheet1 list box.
now see sheet 2 Listbox
I want sheet1 and sheet2 should show the same expand and collapse and vice versa.
but nothing working.
can you post a short video, how you are doing these things perfectly?
not able to upload any pic or gifs to the forum right now. I uploaded the gif to my dropbox:
Yes, same i want as whenever i click on + sign of any of list box , it should work vice versa.
so that i can use it in different sheets .