View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ptaylor[_2_] ptaylor[_2_] is offline
external usenet poster
 
Posts: 3
Default Multiselect list box

I have created a list box on a worksheet and can set its
properties in VBA as follows:

ActiveSheet.Shapes("ListBox1").ControlFormat.ListF illRange
= "B5:B8"
ActiveSheet.Shapes("ListBox1").ControlFormat.Multi Select
= xlExtended

How do I determine the list items that have been selected?
The .Selected(index) (boolean) property is not a property
of the ControlFormat object.

TIA
P Taylor