listbox and excel hjelp......

[ssaifan]

i have a list of 5 names in column B and values in column C next it ....

now...i want to see those names in a listbox.....

and then once that happens ....i want to select one of those names in the l
combo box ..

how can i do this .....

pls help

 

[rs2k]

Highlight the 5 names, goto the name box on the formula bar (the box above column A) and type Names followed by enter.
Pick any cell lets say A1
Then Data|Validation, choose list and in the Source type
=Names
Click OK.
Click A1 and a arrow will appear, click that, and there is your list.

Is one way of doing it.
Colin.