Excel: Experiencing loss of command controls when selecting listbox to open chart
Experts:
I was wondering why this occurs when I hit the arrow button in my dashboard, the chart doesn't open when
I click it. I was told that the button is not firing but there is a way to call that command and create a transparent box that would go behind the arrow button. I was hoping someone can explain a bit more on this. See previous thread to find more that was explained.
NOC-Reports-r17.xlsm
I was wondering why this occurs when I hit the arrow button in my dashboard, the chart doesn't open when
I click it. I was told that the button is not firing but there is a way to call that command and create a transparent box that would go behind the arrow button. I was hoping someone can explain a bit more on this. See previous thread to find more that was explained.
NOC-Reports-r17.xlsm
Ok - you can replicate this. On Executive Rollup I put a command button on top of your icon on the left, then made it transparent, go into design mode and click on the icon and you'll find the object on top - see properties of that object and that its transparent. double click on the command button and you'll see the code calls the listbox1_lostfocus() routine and hence udpates the chart. if it works the way you like, you can then replicate that on top of all the buttons, as there's really no need to do the sheet visible routine you're doing when you hit the icon. just trying to lose focus by getting out of the listbox. so having the icon there does that for you and the transparent one on the top forces the routine to run regardless of whether you were in the listbox or not.
If there's nothing selected in the listbox and button is hit, it would be impotent just like it is now.
Dave
NOC-Reports-r18.xlsm
If there's nothing selected in the listbox and button is hit, it would be impotent just like it is now.
Dave
NOC-Reports-r18.xlsm
Or just get rid of the Icon and use the command button with a <-> text caption...
Dave
Dave
ASKER
Okay, so I did what you recommend and just got rid of the icon and that works perfectly. Not sure if you want me to post another question but I found another issue. lol When selecting from list2 it will update the chart, which is great. However, if I directly go and change the to 3 month view it selects whatever is highlighted in list1 as the new chart with shows the 3 month view.
I understand that the ob are firing ListBox1_LostFocus but it should be ListBox2_LostFocus. Any thoughts on how to resolve this issue? This seems a liitle bit tricky to fix.. It is like eith you choose to keep it the way it is or remove the command from list2..
NOC-Reports-r18.xlsm
I understand that the ob are firing ListBox1_LostFocus but it should be ListBox2_LostFocus. Any thoughts on how to resolve this issue? This seems a liitle bit tricky to fix.. It is like eith you choose to keep it the way it is or remove the command from list2..
NOC-Reports-r18.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked perfectly! Just completed the majority of the repetative task. I added 2 more list box and modified the fire command to trigger. Thank you!
So I have another question that I am about to post. This is related to creating a list box that will populate with the total count and average of EACH selected ID#. I have setup the dashboards with a listbox but just need expert guidance on what is the best way to approach this. Posting now ith new version update
So I have another question that I am about to post. This is related to creating a list box that will populate with the total count and average of EACH selected ID#. I have setup the dashboards with a listbox but just need expert guidance on what is the best way to approach this. Posting now ith new version update
ASKER