Using "List Box" Single-Selection to Transfer a List to "Some Other Box or Cell"

[SLG00001]

Please tell me if I'm asking a question previously answered, I did not find it.

---Images---

==================

---/Images---

I want to use a List Box in which I click a location to have another box display what is in the corresponding location.

I use location meaning location B2 ([73]SLGpaladin) will be a container whereas the contents of B2
(displayed in the second box or cell) are "C2, D2, ..., ZZ2". (and the contents of B3 are "C3, D3, ..., ZZ3")

My output cell for the List Box selection's column value on sheet2 is cellM44 on sheet1.

Sheet1 has the List Box and Sheet2 has the data.

Are you able to tell me how to do this, or redirect me to another topic that does?

If it cannot be done as a whole, I'd appreciate a run-through of how do do a cell-by-cell equivalent of this.

Thank you for reading my question.

 

[jindon]

Your second image is hard to see...

1) Are the listboxes on the sheet from ActiveX (from toolbox) ?
2) in your second image, is there any data in Col.A ?
3) How are you populating the list of 1st listbox ?

 

[SLG00001]

Jindon,

I apologize, I was cheap and uploaded to ImageShack, the images you see are actually URLs to the better images.

1. No. The list box is in Form Control.
2. Not influential data. Column A is intended as indicators for the parent locations of the containers I'm interested in.
3. Sorry? Populating? Skipping me not knowing, I gave the List Box these settings in Format Control.

Input Range: Sheet2!$B$1:$B$48

Cell Link: M44
​

 

[jindon]

Can you change those form listbox to activex listbox ?
It is more flexible to hadle...

 

[SLG00001]

Jindon,

I now have an ActiveX list box that does the same operation, only now when I select option A, the cell link says option A instead of 1.

 

[jindon]

OK,

Can you confirm that

1) the list starts from Col.B (List for ListBox1) and no blank row(s)/column(s) within the list area.
2) when ListBox1 clicked, you want corresponding data from col.C to ... in the ListBox2
3) For ListBox2, you want to avoide any blanks ? (seems there are some in your image)

If so, Can you also give me the name of the sheet that has the raw data(List) ?