List Box via VBA & ADO into Excel2000.

[Guest.Visitor]

I am stuck.. (my head hurts and the blood on the wall is a mess) I am trying to load a list box via an ADO recordset (loaded w/ SQL), then have the user select one of the entries from the list box to be placed in a cell. A snippet of code would be much appreciated. Thanks Signed: Batter, Bludgeoned, and Covered.

[Guest.Visitor]

In one of the previous issues of MC there is an example of just that, the code is on the website for you to download. Sorry I don't remember which issue, but it is not that long ago. Greg

[Guest.Visitor]

My subscription started in Jan 2000. I have both examples since that date. Neither of which have this as an example. (I am successfully connecting and retrieving data. I'm just having trouble creating this list box in which to select.)

[Guest.Visitor]

look on the website, I think the one for VB is back in Oct of 1998. It is def in 1998 though. Greg

[Guest.Visitor]

I went to 98 section, but no luck finding a list box loaded from ADO & SQL that you can select an entry from. Anyone else?? If I missed it please cut and paste it here for others to see.