LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Active X list box MultSelectExtened issue

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to list all active macros and their assigned keystrokes? z.entropic Excel Worksheet Functions 2 October 5th 07 03:29 PM
list sheet names vertically below the active cell - need macro. Eddy Stan Excel Worksheet Functions 2 September 28th 07 07:48 PM
Active X List Box dgrimes1 Excel Discussion (Misc queries) 0 December 8th 05 04:42 PM
Delete column not active on List toolbar June Whipple New Users to Excel 1 November 17th 05 06:04 PM
Active / Dynamic Filtered List (changes w/ change in cell value) [email protected] Excel Discussion (Misc queries) 3 March 31st 05 04:03 PM


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"