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.