Thread: Babylon 5 Mod
View Single Post
  #3558  
Old November 8th, 2003, 02:28 AM

XenoTheMorph XenoTheMorph is offline
Corporal
 
Join Date: Sep 2003
Location: London, UK
Posts: 134
Thanks: 0
Thanked 0 Times in 0 Posts
XenoTheMorph is on a distinguished road
Default Re: Babylon 5 Mod

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
__________________
Xeno.

A Pessimist is just an Optimistic Realist.
Reply With Quote