P
Paul_W
I'm using a couple of active X list boxs on a worksheet with an embeded chart
to control the plot series data ranges (in conjuction with some VBA code).
Everything seems to be working ok except the behavior of the list box during
the user selection process.
For example one item is selected in the list box and a plot generated. If a
second item is attempted to be selected using the control key + mouse click
and added to the plot all the items between the first and second would be
highlighted as though the shift key were depressed. If the user clicks a
couple of times in the list box until just a single item is selected and then
proceeds with adding additional entries the MultiSelectExtended behaves as
expected.
Is there a way to fix this?
I've heard that the forms controls are more robust, but I'm not sure if they
can remain visible next to a embeded chart on a worksheet while interactively
changing the plot series multiple times?
Thanks in advance
to control the plot series data ranges (in conjuction with some VBA code).
Everything seems to be working ok except the behavior of the list box during
the user selection process.
For example one item is selected in the list box and a plot generated. If a
second item is attempted to be selected using the control key + mouse click
and added to the plot all the items between the first and second would be
highlighted as though the shift key were depressed. If the user clicks a
couple of times in the list box until just a single item is selected and then
proceeds with adding additional entries the MultiSelectExtended behaves as
expected.
Is there a way to fix this?
I've heard that the forms controls are more robust, but I'm not sure if they
can remain visible next to a embeded chart on a worksheet while interactively
changing the plot series multiple times?
Thanks in advance