Question: how to select a value in excel drop down using vba?
Answer: Select cell B2., Go to tab "Data" on the ribbon., Click the "Data validation" button and a dialog box appears., Click on the Drop Down list below "Allow:" and select "List"., Type your macro names in Source: field, separated by a comma., Click OK button.