Question: how to get the selected value of dropdown in excel?
Answer: Create a drop down list. ... 
Then in the Data Validation dialog, under Settings tab, select List from Allow list, and then select the value you want to show in the drop down list to Source textbox. ... 
Then click Error Alert tab in the Data Validation dialog, and uncheck Show error alert after invalid data is entered option.