A workaround for .ListIndex??

[nigelandrewfoster]

Hello!

Using Excel for Mac 2011 I discovered that .RowSource is not implemented. Found a workaround for that one. Now it seems the ability to set the .ListIndex property isn't either. Any suggestions how I might change the highlighted selection of a listbox without it?? These properties have been around since the year dot on the PC, why on earth haven't they been added in updates since they were missed when the software was released...?

Thanks for your time.

Nigel

 

[RoryA]

ListIndex does work in Excel 2011 (unless you have a multiselect listbox).

 

[nigelandrewfoster]

ListIndex does work in Excel 2011 (unless you have a multiselect listbox).

Hi Rorya

You can READ the property but not WRITE to it it seems

 

[RoryA]

Nope - you can write to it.

 

[nigelandrewfoster]

Really? I was getting error 380 - same as with RowIndex,so perhaps I am jumping to conclusions as to the cause. I changed all my list boxes to combo boxes before I got your reply and it's working on both Mac and PC now. Perhaps when I get more time I will revisit the code to discover what it was about my list boxes the Mac didn't like. Thanks again for your time.