creating a dropdown dynamically in multiple rows & assiging values to it from database

i jst have the above code for creating dropdown for the range of rows in a partcialr column
how do i create a reference in vb.net & access it in vba workbook?