Posted to microsoft.public.excel.programming

ptaylor[_2_] ptaylor[_2_] is offline

external usenet poster

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
can I have a multiselect option for a list box in excel 2003	pascaleinlove	Excel Discussion (Misc queries)	1	March 15th 10 06:41 PM
How do I create a multiselect drop down list	Yve	Excel Worksheet Functions	2	January 22nd 09 07:29 PM
Multiselect Listbox	Francis Ang[_3_]	Excel Programming	0	October 27th 04 02:21 AM
multiselect listbox	CG Rosén	Excel Programming	2	December 28th 03 05:17 PM
Multiselect Boxes	Jase	Excel Programming	2	October 22nd 03 03:40 AM

All times are GMT +1. The time now is 03:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us