View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ZipCurs ZipCurs is offline
external usenet poster
 
Posts: 103
Default Shapes into List Box

Thanks for the suggestion, will try when time permits. Does the ListView
behave like a ListBox, allowing multiple items to be selected? Can items be
put into the ImageList from within the worksheet? All I am trying to do is
create an interactive graph legend.

"Nile_Hef" wrote:


Rather than drag-and-dropping an MSForms Listbox off the 'Tools' menu, click
the 'More Controls...' button and fetch two controls: a Microsoft ListView
6.0 control and an ImageList. You'll need C:\WINNT\system32\comctl32.ocx

The imageList can store small bitmaps and icons; the Listview control can
reference an ImageList and display icons alongside each entry. This needs
some VBA coding, to associate the correct ison with the correct line, but
it's a standard ActiveX interface.

Nile