combo box from control toolbox

[Guest]

Hi

i know i asked smilier question before but this time is different!
Ok i am going as simple as i can, i have sheet and have on ColumA "NAME" and
on ColumB "Phone No". and on sheet two i have Combo box that from the Control
Toolbox, NOT from Forms, so what i want is when i select name from combo box
i want to see the phone number of that person to show up below the combo box?
Thanks guys for all your help.

 

[Guest]

.. i have sheet and have on ColumA "NAME" and on ColumB "Phone No".
and on sheet two i have Combo box that from the Control
Toolbox, NOT from Forms, so what i want is when i select name from combo box
i want to see the phone number of that person to show up below the combo box?

One play ..

Assume source data is in Sheet1!A2:B100
col A = names, col B = phone nos

In Sheet2,

Assume the combo box is placed over A9

In design mode, right-click on the combo box > Properties

Set the properties of the combo box to:
ListFillRange: Sheet1!A2:B100
LinkedCell: A10
BoundColumn: 2
ColumnCount: 1

Test it out ... the combo box droplist will display only the names, &
selecting the name will place the corresponding phone no into the link cell:
A10

If we set ColumnCount to 2, then the droplist will display both names &
phone nos

---