Populate list box with a named range

vba excel listbox named-ranges
cazzzac picture cazzzac · May 8, 2014 · Viewed 25.5k times · Source

I'm working on my first ever VBA project, and need a bit of absolute newbie guidance.

  1. I have a submission form that staff will be using to submit their daily KPIs.
  2. I have a list box control in a user form called "lstName" that employees will use to select their name before submitting the form
  3. Employee names are stored in a named range on "Sheet11" called "EmpName".

I want to direct the list box to draw the list of names from the "EmpName" range on Sheet11; but don't know how I would do this in VBA. I was going to use RowSource to point the list box to the data, but I am lost as to how to do this.

Really simple question I know, and it has probably been answered in some way on the site, but since I'm completely new to VBA, the answers were beyond me. If someone could provide a stepped out answer that explains what the code is doing that would be amazing!

Answer

user2140173 picture user2140173 · May 8, 2014

Select your Userform and your ListBox, turn on Properties Window (View -> Properties or F4)

In the Properties Window navigate to the RowSource property and type Sheet11!EmpName

A simple boo example

enter image description here

Related questions

How to get selected value in multicolumn listbox

I have a multicolumn listbox in my userform and I would like to get all the values of the elements which are in the selected row in the listbox.Here is my userform: Just like in the photo, I want …

Read More
VBA Excel Populate ListBox with multiple columns

This may be a cheap question for some but I'm totally confused on how to populate my listbox. Using this line I can populate the listbox as shown below: ListBox1.List = Sheets("Sheet1").Cells(1, 1).CurrentRegion.Value or Dim rngName As …

Read More
How to filter listbox values based on a Textbox value

I have a textbox and a listbox on userform. I want to filter the values in listbox based on the value I enter in Textbox. Sheet named TMP has the values and I filter it based on textbox change event …

Read More