Fill Listbox

[Terry]

I would like to fill a listbox with a 2 column valuelist and hide the value
in the first column as available in VBA. I have tried .items.add and
item.addrange but cannot seem to get the desired result. I am using the form
Load event to fill the listbox.
Regards

[Herfried K. Wagner [MVP]]

"Terry" <ne*******@whit eHYPHENlightDOT me.ukschrieb:

>I would like to fill a listbox with a 2 column valuelist and hide the value
in the first column as available in VBA. I have tried .items.add and
item.addrang e but cannot seem to get the desired result. I am using the
form Load event to fill the listbox.

Add the items to a "collection " ('DataTable', for example), assign it to the
control's 'DataSource' property and set its 'DisplayMember' and
'ValueMember' properties according to your needs.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Newbie Coder]

Its not very often I agree with Herfried, but I do in this situation.

OMG! I am slipping! Help!!!!!!!!!!! !!!!!!!!!!!

--
Newbie Coder
(It's just a name)

[Cor Ligthert [MVP]]

Terry,

For this you have to fill class objects to the itemlist from a listbox.

You have to cast those when you need them. In fact you can use endless
columns.

(I normally give always the samples of datatables and than comes Herfried
with this class/object answer, I was supprised that he gave now my standard
answer).

Cor

"Terry" <ne*******@whit eHYPHENlightDOT me.ukschreef in bericht
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>I would like to fill a listbox with a 2 column valuelist and hide the value
in the first column as available in VBA. I have tried .items.add and
item.addrang e but cannot seem to get the desired result. I am using the
form Load event to fill the listbox.
Regards

[Master Programmer]

On Feb 5, 6:22 am, "Terry" <news-g...@whiteHYPHE NlightDOTme.ukw rote:

I would like to fill a listbox with a 2 column valuelist and hide the value
in the first column as available in VBA. I have tried .items.add and
item.addrange but cannot seem to get the desired result. I am using the form
Load event to fill the listbox.
Regards

Me.myList.Items .Add(New ListItem("My_Di splay_Text",
"My_Hidden_Valu e"))

The Grand Master

[Terry]

Thanks for all the help.

I have decided to use a small SQL table which will allow me to easily add
new rows without having to re-code. I had needed to create the database for
this project so have taken this opportunity to learn something about
SQL2005.

Regards
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:ew******** ******@TK2MSFTN GP03.phx.gbl...

Terry,

For this you have to fill class objects to the itemlist from a listbox.

You have to cast those when you need them. In fact you can use endless
columns.

(I normally give always the samples of datatables and than comes Herfried
with this class/object answer, I was supprised that he gave now my
standard answer).

Cor

"Terry" <ne*******@whit eHYPHENlightDOT me.ukschreef in bericht
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>>I would like to fill a listbox with a 2 column valuelist and hide the
value in the first column as available in VBA. I have tried .items.add and
item.addran ge but cannot seem to get the desired result. I am using the
form Load event to fill the listbox.
Regards