List Box question

**ballack** · 05-23-2007, 01:17 AM

Hi all,
I created an excel sheet which has many drop down list boxes. I have written the data for these list boxes in my excel sheet itself .

But i dont think having list box values in the excel sheet itself is not right .

Is there any way where i can enter an array of these values in VBA and populate the list box from these arrays?

Thanks you.
Glen.

**royUK** · 05-23-2007, 03:41 AM

Are you using a single column listbox/ If so this will populate ListBox one each time the sheet is accessed. Place it in the Worksheet object

Quick Instructions On How to Add Code to a Sheet Object
Open the VBE (Alt+F11) and then double click the Sheet in the Project Explorer the code applies to. This is where the code MUST be placed.

Please Login or Register  to view this content.

**ballack** · 05-23-2007, 06:00 AM

Roy, i didnt understand what is 'ListBox1' .
I dont see any option to name a Listbox.

To define a listbox i go to Data->validation . and in settings i set the Type as List and define the range in excel sheet where i should get the values to populate the list box.

So if i dont want to have my list box data in the excel sheet and populate the data from VBA arrays how can i do it?

**royUK** · 05-23-2007, 07:22 AM

That's not a listBox, it's Data Validation!

In the Data validation Wizard instead of typing a Range you can type your list separated by commas - see the Data Validation Tutorial here

List Box question

LinkBack

Thread Tools

Rate This Thread

Display

List Box question

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions