Worksheet.DropDowns.Add(Worksheet.Range(Erow, Erow).Left, Worksheet.Range(Erow, Erow).Top - 1, Worksheet.Range(Erow, Erow).Width, Worksheet.Range(Erow, Erow).Height).caption = ""
i have teh above code from vb.net to create dropdown in excel dynamically

this is working fine
the dropdowns are displayed in each row as per the range given
i am openinng excel from Vb.net

the issue is each dropdown has differnt name
i need to populate all the dropdowns created with data from datbase in vba

as the dropdowns r created dynamically how do i get the names to populate the dropdowns in vba