PC Review


Reply
Thread Tools Rate Thread

Create ListBox and Populate with Array

 
 
=?Utf-8?B?TWF4?=
Guest
Posts: n/a
 
      29th Oct 2007
Hi - Help this noob out...

I want to create an array and then take the data contained in that array and
place it in a ListBox so that users can then select values (one to many)
within that List box.

1) How do I create the ListBox?
2) How do I put the data in the the array into the ListBox?
3) How do I capture the selections to be used later?

--
Thanks!
Max
 
Reply With Quote
 
 
 
 
dan dungan
Guest
Posts: n/a
 
      29th Oct 2007
Hi Max,


> 1) How do I create the ListBox?


In Excel 2000,
a) With the mouse, choose Help
b) Type list box in the Answer Wizard box "What would
you
like to do?
c) Click on "Add ActiveX controls from the Control
Toolbox"

This should take care of 1, 2 and probably 3, as well.

hth

Dan Dungan

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array to Populate ListBox Problem pallaver Microsoft Excel Misc 1 25th Jul 2008 08:50 AM
Populate an array that is a subset of a larger array? =?Utf-8?B?SmVmZg==?= Microsoft Excel Worksheet Functions 1 25th Sep 2007 12:51 AM
Populate listbox from array =?Utf-8?B?Sg==?= Microsoft Access VBA Modules 3 9th Apr 2005 01:05 PM
populate 1 listbox with another listbox and vice versa Dave Microsoft VB .NET 5 5th Jan 2005 06:58 AM
Access 97: Populate ListBox based on another ListBox Mark Breitfeller Microsoft Access Form Coding 0 30th Sep 2003 07:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:27 AM.