Well I've never used a list_box in my life
But after extensive
testing (Excel 2000 only)-
1. Open the View menu and goto Toolbars > Forms.
2. On the Now visible Forms Menu choose the 4th icon down on the Left (at least in Excel 2000), place/size the listbox
3. Now Right-Click (you can assign a macro at this stage, for when the listbox is selected) to get the properties.
4. In properties you can of course cahnge the size of the box, also on the Control Tab You can assign the cells to get the list from (directly or by an assigned name), and the cell/s to write to.
O.K. thats the basics and I still don't know how to use them properly (for similar stuff I normally use the Data Validation List option). I have only been able to get them to output the number of the option on the list to the written to cell, and only with the Single selection option.
Best of luck
