| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. -- ingleg ------------------------------------------------------------------------ ingleg's Profile: http://www.excelforum.com/member.php...o&userid=33037 View this thread: http://www.excelforum.com/showthread...hreadid=558494 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox on a useform
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox on a useform
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox on a useform
ListFill should be RowSource.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... 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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Listbox on a useform
Thanks Chip. I tried the Row source previously, but must have mis-typed the cell reference. -- ingleg ------------------------------------------------------------------------ ingleg's Profile: http://www.excelforum.com/member.php...o&userid=33037 View this thread: http://www.excelforum.com/showthread...hreadid=558494 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add Listbox header using VBA | Excel Discussion (Misc queries) | |||
| Using a ListBox selection to query a database | Excel Discussion (Misc queries) | |||
| Need help with Listbox | Excel Discussion (Misc queries) | |||
| Help with Excel ActiveX listbox controls | Excel Discussion (Misc queries) | |||
| multiple columns / rows to be referenced through a listbox | Excel Discussion (Misc queries) | |||
Linear Mode
