I have created the excel file with two sheets. one sheet contains the columns, below that columns we have dropdowns for some columns and that dropdown values get filled with values which are in the second sheet.
I am sending my code and exported excel file as an attachment.
Please Check it, where I am lacking and suggest me how to get my dropdown values.
Also I have created listbox instead of combox in exported excel file. I have tried but not getting.
I am attaching the exported excel file by name “ImportStudentFromExcel-1”. Please suggest me
how to getting listboxes in place of combox.
Could you create sample Excel file in MS Excel to show
By the way, we think you can try List Validation.
For more information about List Data Validation, check: