Listbox on a useform

I am trying to add a listbox to a userform, but cannot work out how to add a list to the listbox!

Any ideas?

Thanks in advance.

If you want to fill the list with values from a worksheet range,
set the ListFill property to that range. Otherwise, use the
..AddItem method:

With UserForm1.ListBox1
.AddItem "a"
.AddItem "be"
.AddItem "c"
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"ingleg" <[email protected]>
wrote in message
news:[email protected]...
>
> I am trying to add a listbox to a userform, but cannot work out
> how to
> add a list to the listbox!
>
> Any ideas?
>
> Thanks in advance.
>
>
> --
> ingleg
> ------------------------------------------------------------------------
> ingleg's Profile:
> http://www.excelforum.com/member.php...o&userid=33037
> View this thread:
> http://www.excelforum.com/showthread...hreadid=558494
>

You either add each item

With Listbox1
.Additem "Bob"
.AddItem "Jim"
'etc.

End With

or else you link it to a worksheet range, via the RowSource property.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ingleg" <[email protected]> wrote in
message news:[email protected]...
>
> I am trying to add a listbox to a userform, but cannot work out how to
> add a list to the listbox!
>
> Any ideas?
>
> Thanks in advance.
>
>
> --
> ingleg
> ------------------------------------------------------------------------
> ingleg's Profile:
http://www.excelforum.com/member.php...o&userid=33037
> View this thread: http://www.excelforum.com/showthread...hreadid=558494
>

ListFill should be RowSource.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> If you want to fill the list with values from a worksheet
> range, set the ListFill property to that range. Otherwise, use
> the .AddItem method:
>
> With UserForm1.ListBox1
> .AddItem "a"
> .AddItem "be"
> .AddItem "c"
> End With
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "ingleg" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> I am trying to add a listbox to a userform, but cannot work
>> out how to
>> add a list to the listbox!
>>
>> Any ideas?
>>
>> Thanks in advance.
>>
>>
>> --
>> ingleg
>> ------------------------------------------------------------------------
>> ingleg's Profile:
>> http://www.excelforum.com/member.php...o&userid=33037
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=558494
>>
>
>

Thanks Chip.

I tried the Row source previously, but must have mis-typed the cell reference.