excel VBA如何创建下拉列表

i want to make all the rows in the second columns to be a drop down list. where the user click on the cell and select any existing name.i want to make all the rows in the second colum